b****k
发帖数: 23 | 1 由于不能展示图片，原文可以参考
http://www.cnblogs.com/biwork/p/4165649.html
微软BI SSIS 2012 ETL 控件与案例精讲 （http://www.hellobi.com/course/21） 课程从2014年9月开始准备，到2014年12月在 天善BI学院 （http://www.hellobi.com）正式上线。
•100多天的时间共完成了 51个视频的录制，包含49个原创案例，总共1460余分
钟，共计 24 个小时。
•每一个案例的准备时间耗时 4 - 5个小时，有的案例的设计，思路的整理耗时
8 个小时 - 16 个小时。
本课程涵盖了微软 BI SSIS 几乎所有常用控件的讲解，讲解的内容不是按照书本照本
宣科的简单的告诉大家如何使用，而是通过大量的案例，代码对各个知识点进行穿插讲
解。每一个基本案例都是由我个人原创，并加入了个人的测试，总结和归纳部分。每一
个案例自始至终，来龙去脉，所有的代码和实现操作过程均在视频课程中一步一步现场
编程和实现。因此大家是完全可以按照视频中的操作步骤实现所有讲解的... 阅读全帖 |
|
i****a
发帖数: 36252 | 2 question:
1. easy way to avoid error with data conversion?
you mean the date fields you either have to fix it before import, or do
error handling during import.
in Access, write a query:
select id, cdate(dateofbirth) from table_SourceA
you'll get error on invalid dates
you can use data converter in SSIS and you can configure it's error handling
, if I remember right
2. easy way to add one column with the value of filename?
yes, in SSIS you can define a variable for the table name and map that as... 阅读全帖 |
|
Y****3
发帖数: 963 | 3 SSYS - 09:33:30
Bought 100s @ $41.8999 - Total: $4,196.99
SSYS - 09:33:30
Bought 200s @ $41.8967 - Total: $8,379.34
SSYS - 09:40:25
Sold 100s @ $42.92 - Total: $4,284.92
SSYS - 09:40:25
Sold 100s @ $42.92 - Total: $4,291.92
SSYS - 09:40:25
Sold 100s @ $42.92 - Total: $4,291.92 |
|
D*******z
发帖数: 319 | 4 Here is the error message. Any ideas? Thanks.
Started: 3:00:00 AM Error: 2011-09-26 05:53:00.76 Code: 0xC02020A1
Source: Data Flow Task 1 Destination - astromembers_txt [154]
Description: Data conversion failed. The data conversion for column "
FirstName" returned status value 4 and status text "Text was truncated or
one or more characters had no match in the target code page.". End Error
Error: 2011-09-26 05:53:00.76 Code: 0xC02020A0 Source: Data Flow
Task 1 Destination -... 阅读全帖 |
|
d**********3
发帖数: 1186 | 5 Meeting Aganda,
#1, SQL PASS Global Chinese Community Updates
#2, Session Sharing: SSIS Best Practice
Session Audience: Intermediate Level SSIS Developers/ BI Developers
Session Description:
Trying to introduce a frequently-used pattern of SSIS package design. It
covers most of frequently-used features in SSIS and examines the pros and
cons.
#3, Open discussion for your questions(Any questions)
Date: Jan 27, 2014
Time: 8:00 PM CST/9:00 PM EST
Please register the event at:
https://att... 阅读全帖 |
|
n***l
发帖数: 27 | 6 我有一个excel文件在一个folder里，我想设计一个SSIS package，如果excel data没
有变动，不fire这个SSIS package；如果excel data有update insert delete，就fire
这个SSIS package，loading这些变动到sql table里，并发送email通知我。请教各位
大大，该如果设计这个SSIS package呢？多谢了。 |
|
k*****n
发帖数: 361 | 7 从一个SQL server move 数据到另一个 SQL server，目的地SQL server有个database
owner dbo权限
但是存放SSIS package指定好目的地SQL server还是出错说没有SSIS execute
permission
是要和dba说加SSIS permission还是有另外的办法？
试过存在自己local 的PC上肯定不行，对不？ |
|
r*****m
发帖数: 3619 | 8 此次起义，必然是沦为少数的白人中产拿起武器，夺回合法收入的正义斗争。
中产的要求是全部废除Obamacare，确保 Medicare，SSI benefits。废除联邦税，夺回
部分 SSI benefits
在这个正义斗争中，我们全力破坏绞死米犹花街金融，全力制造米犹 budget crisis，
逼迫米犹还债。
直接资助美国民兵，陈光标免费向民兵捐送生活物资。 |
|
j*****n
发帖数: 1781 | 9 【 以下文字转载自 Database 讨论区 】
发信人: jackrun (Michael Jackson is dead :((), 信区: Database
标 题: 招工：SQL Server developer w. SSIS
发信站: BBS 未名空间站 (Thu Oct 1 23:00:50 2009, 美东)
Our Company needs a SQL Server Developer, H1 sponsorship is possible.
Junior to Middle level.
SQL Server 2005/2008, 2+ years exp. Best to have Data warehouse experience,
we have 5TB+ data and it is growing very fast.
Minimum 1 year SSIS experience required.
SSRS/SSAS are plus.
You must be a multitask person can handle some stress.
O |
|
B***S
发帖数: 73 | 10 SSIS Developer
Location: Chicago, IL - Locals preferred
Required Skills / Experience
. Expertise in BI, Data Warehousing design & implementation,
Cubes, ETL, SQL, Microsoft BI Suite
. 3+ years' experience in SQL development environment
. 3+ years of SSIS development experience
. Strong experience in Transact SQL and stored procedure
development
. Experience with ETL design and development
. Experience SQL SERVER ... 阅读全帖 |
|
c*****0
发帖数: 3 | 11 MS SQL 2008 R2 ). Must have done lot of SSIS, EDW design on SQL Server 2008.
Candidate should live in USA. Work from home opportunity.
Developer - ETL & Data Warehouse
Seeking multiple BI / Data Warehouse Developer / Architects for a global
fortune ten technology client to work on the Microsoft BI Platform. The
candidates need to be dynamic, mature, ambitious, creative, and
autonomous
as the team is Senior Level and experienced in building ETL and data
warehouse. Main... 阅读全帖 |
|
c*****0
发帖数: 3 | 12 MS SQL 2008 R2 ). Must have done lot of SSIS, EDW design on SQL Server 2008.
Candidate should live in USA. Work from home opportunity.
Developer - ETL & Data Warehouse
Seeking multiple BI / Data Warehouse Developer / Architects for a global
fortune ten technology client to work on the Microsoft BI Platform. The
candidates need to be dynamic, mature, ambitious, creative, and
autonomous
as the team is Senior Level and experienced in building ETL and data
warehouse. Main... 阅读全帖 |
|
j*****n
发帖数: 1781 | 13 【 以下文字转载自 Database 讨论区 】
发信人: jackrun (Michael Jackson is dead :((), 信区: Database
标 题: 招工：SQL Server developer w. SSIS
发信站: BBS 未名空间站 (Thu Oct 1 23:00:50 2009, 美东)
Our Company needs a SQL Server Developer, H1 sponsorship is possible.
Junior to Middle level.
SQL Server 2005/2008, 2+ years exp. Best to have Data warehouse experience,
we have 5TB+ data and it is growing very fast.
Minimum 1 year SSIS experience required.
SSRS/SSAS are plus.
You must be a multitask person can handle some stress.
O |
|
i***0
发帖数: 8469 | 14 My name is Pinky and I'm a recruiter at Artech, a global staffing and IT
consulting company. We are constantly on the look out for professionals to
fulfill the staffing needs of our clients, and we currently have a job
opening that may interest you. Below is a summary of the position.
Job Title: SDE SSIS WCF
Location: Redmond, WA
Duration: 6+ Months
Job Description:
MUST HAVE skills/experience: SSIS and WCF
Candidate will be performing as trouble shooter for 2 project teams
4 plus years work rel... 阅读全帖 |
|
g*******n
发帖数: 632 | 15 请问有父母住在老人公寓的吗？ 我想问一下怎样给老人申请ssi和医疗保险在华盛顿州？
有没有帮助老人申请SSI和医疗保险的Agent和人？ |
|
j***y
发帖数: 2074 | 16 how to configure Apache to support SSI under NT4.0?
i found in the documentation that i only add the following directives in the
file httpd.conf:
AddHandler server-parsed .shtml
AddType text/html shtml
but it seems that the SSI (Server Side Include) still can't be supported. the
server even can't parse my phrase like in my index.shtml.
any help?
thanks, |
|
j*****n
发帖数: 1781 | 17 yes, it is possible.
SSIS can install independently outside SQL Server database engine. that is,
an independent SSIS server.
you can dynamically create connections by script using VB.net and retrieve
the server, db, and table information from your list. this list can either
stores in a db table or a file. |
|
B*********L
发帖数: 700 | 18 我用SSIS import and export wizard 从Oracle 数据库import 50个表到sql2005. 这
个Package 有时候success,有时候fail, fail的时候不定在那个TABLE，但是error
message 都一样的。
SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code:
0x80004005. An OLE DB record is available. Source: "Microsoft SQL Native
Client" Hresult: 0x80004005 Description: "Invalid character value for cast
specification".
我试着把package 变成一个table一个Data Flow Task然后串起来RUN，但是有这个
ERROR。
大家看看有什么办法呢？
谢谢了。 |
|
j*****n
发帖数: 1781 | 19 Here is a dummy solution....
use SSIS to export Oracle data into a text file (Delimited);
use SSIS to import this text file into your destination table. Better
predefine your destination table first, otherwise the data type may differ
when you create it while you import.
Another solution is that use data conversion component, which could do some
type transformations but is limited.
Sure, changing collations is always a pain in the S.
Let me know which one worked well for you. |
|
B*********L
发帖数: 700 | 20 it works now. instead of create/edit data flow tasks in an old ssis package.
i create a new ssis package, then everything works fine. |
|
j*****n
发帖数: 1781 | 21 it won't be a big deal. most likely this package has been configured but
your BIDS cannot obtain the configuration settings.
After you open it, go to "SSIS"==>"Package Configurations" and un-check the
"Enable Package Configurations" box; click "Close" and then save.
Next time you will not receive this information.
Tip: it is time to learn how to configure your SSIS package. |
|
g***l
发帖数: 18555 | 22 哪里能找到SSIS的VIDEO教程啊，或者EXAMPLE也行，我有两本书，但好像写的不好，以
前DTS学得很好，SSIS变得都不认识了。 |
|
j****s
发帖数: 881 | 23 在SQL Server方面，SSIS, SSAS, SSRS是独立于SQL Server的软件，还是SQL Server中
的一个功能？老是看到SQL Server的工作需要有SSIS, SSAS, SSRS的经验。 |
|
g***l
发帖数: 18555 | 24 可是我的SSIS的VENDOR_ID是INT，用这个SP的原因就是因为SSIS PACKAGE不能改变，所
以必须PASS INTEGER VENDOR_ID,CONVERT TO VARCHAR还是错 |
|
f********y
发帖数: 696 | 25 我又建立了一个测试SSIS Package 传输数据从MYSQL 到MSSQL。 在VS BIDS里运行没有
问题，所有的数据都传过来了。Import 这个Package 到Intergration Service下的
MSDB，执行这个Package，所有的数据也成功地传输过来了。我的问题是我需要建立一
个JOB定期执行它。我建立了credential，建立了proxy account，改变了Package
Protection Level as Rely on server storage and roles for access control，选
择了Use 32 bit runtime in EXECUTINON OPTION，但仍然没有数据传输过来，它报告
THE JOB SUCCEEDED， 但是Data Flow objects cannot be loaded. Check if
Microsoft.SqlServer.PipelineXml.dll is properly registered
Description: Data Flow objects cann... 阅读全帖 |
|
d**********3
发帖数: 1186 | 26 How did u deploy the package?
If you deployed to SSIS instead of file mode, you should find this info in
SSIS(through SSMS).
But still questions for you,you did not expose connection managers in XML/DB?
if not, how u make it work after moving ur packages in DEV to Prod? |
|
s**********o
发帖数: 14359 | 27 SSIS要每天输出一个动态的EXCEL，比如REPORT20131001.XLS, REPORT20131002.XLS
等等，这个SSIS的DATA FLOW TASK居然HANDLE不了动态的EXCEL DESTINATION，
非要搞个TEMPLATE, COPY FILE，或者用CMDSHELL去创建，这也太土了，
这么一个基本的报表输出问题，都这么费劲 |
|
|
w****n
发帖数: 266 | 29 We installed SQL server 2012 on a test server with SQL server 2008 aside and
wanted to upgrade all SSIS 2008 packages to 2012. I copies the packages to
a new location on the same server, upgraded to SSIS 2012 with Visual Studio
2010, changed the shared data sources to SQL 2012. The project is with
package deployment model and some packages reference to other packages in
the same project, when I tried to change the external referenced package(in
the same project) to the new location, if the exter... 阅读全帖 |
|
|
w****n
发帖数: 266 | 31 新人刚工作两年，一直在用SSIS, 现在有一职位用Cognos，不知是否值得一试，只比较
技术和今后职业发展。不知别人是否会考虑SSIS背景的人？多谢. |
|
s**********o
发帖数: 14359 | 32 我要UPGRADE SSIS 2008到2012,SERVER上有好几个百个SSIS PACKAGES，好几百个JOBS
如果一个一个的PACKAGE去UPGRADE还不累死，而且也没法TEST，我怎么知道WORK不WORK
有的还有CONFIG FILES，2012都没有CONFIG FILES，用什么PARAMETER了，看来这个
UPGRADE
不是一般的复杂。 |
|
r****z
发帖数: 4 | 33 我需要自动存所有的SQL SERVER TABLES DAILY because users need to run queries
to compare the data changes for any specified periods. I plan to use SSIS
and ask SQL Server ADMNIN to set up scheduler to run it automatically. I
only have 2 days to complete it including weekends. I have never used SSIS
before. Is there a quick way to learn it? It seems it is hard to learn it
quickly. BTW, I use sql server management studio
Thanks! |
|
|
c**********6
发帖数: 26 | 35 one option for friends who want to get training and job on BI SAS
Informatica ETL SQL Server SSIS SSRS SSAS Cognos etc. thanks.
渴望求职？转行？进修？
申请BI工作有面试无结果？我们可以你帮助您！
成功只差一步！
祝贺国内医学博士晶女士，住家多年后参加培训已成功获得第一份商业智能好工作！
祝贺美MBA丽女士，住家多年后已成功获得第一份商业智能好工作！
祝贺美化学博士陆先生，已成功转行获得高薪稳定的商业智能BI工作！
USA BI Training Star 面向全美各地；在线商业智能职业培训 (773) 982 - 8168
我们的培训给希望求职转行进修的朋友一个新的选择。
短平快职业培训课程：
• SQL Server (SQL, SSIS, SSRS, SSAS)
• Oracle
• SAS 9.x (based, advanced, workshop/project in bank/ins... 阅读全帖 |
|
b**i
发帖数: 932 | 36 【 以下文字转载自 Stock 讨论区 】
发信人: Lkj888 (傻福), 信区: Stock
标 题: 12/19 罗薇 的 骑虎 VS 大夫的 SSYS 原帖
发信站: BBS 未名空间站 (Fri Feb 28 23:13:52 2014, 美东)
招财猫要pick 贴
http://www.mitbbs.com/article_t/Stock/35226409.html
发信人: Lexian (蒙古大夫), 信区: Stock
标 题: Re: 求今天能捞的pick，我是真的要买
发信站: BBS 未名空间站 (Thu Dec 19 14:05:06 2013, 美东)
好心给你一个吧， 刚进的SSYS。
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
发信人: Lexian (蒙古大夫), 信区: Stock
标 题: Re: 求今天能捞的pick，我是真的要买
发信站: BBS 未名空间站 (Thu Dec 19 14:06:37 2013, 美东)
人家给了奇虎。
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~... 阅读全帖 |
|
j*****n
发帖数: 1781 | 37 【 以下文字转载自 Database 讨论区 】
发信人: jackrun (Michael Jackson is dead :((), 信区: Database
标 题: Update: 招工：SQL Server developer w. SSIS
发信站: BBS 未名空间站 (Thu Oct 1 23:00:50 2009, 美东)
It was confirmed with HR this morning, unfortunately the company does not sponsor fresh H1b fillings, only transferring is available. |
|
s********e
发帖数: 340 | 38 有面试过 SQL Server BI SSIS SSAS, SSRS 的人么？
这方便都有什么面试题，有经验的帮忙推荐一下如何准备吧。我要面试一个这方面的工
作。谢谢！ |
|
c********y
发帖数: 32 | 39 Big public Company need a full time MS Database Developer with strong ETL/
SSIS, TSQL experience for Sql 2005,2008.
at least 3 years of experience.
US citizen, Greencard, EAD, H1 transfer for really strong candidate.
resume goes to hiring manage directly. |
|
l**e
发帖数: 218 | 40 因为孩子是早产，申请了SSI的medicaid，那还需要给他们买别的保险吗？ |
|
E*D
发帖数: 22 | 41 这么多国内公司来美国招人，这么多人回去工作。
回国，入籍美国social security 不够40点，国内年薪低于9万6美元（免美税），如何
报ssi税？ |
|
w**t
发帖数: 177 | 42 如图, 在Walmart.com上买了两双鞋, 每个鞋盒子上都贴有这么一个SSI Unit Label,
上面有UserId (但不是我的), 日期和条形码, 这代表什么意思? |
|
b******r
发帖数: 16603 | 43 靠，我刚把ZNGA卖了，可以小买一股SSYS，但DDD看着还在半空的样子。 |
|
b******r
发帖数: 16603 | 44 我有DDD，上周OE被硬塞过来的，准备逃跑，如果SSYS很好，那我就留着？ |
|
|
P******l
发帖数: 1648 | 46 四架马车都爆了
XONE DDD SSYS PRLB |
|
P******l
发帖数: 1648 | 47 2011 IPO
3D service. the other 3 are 3D manufacturer
It held better than ssys/ddd in the last correction of 3D group |
|
m*****y
发帖数: 3981 | 48 老李/宋， 给点SSYS 的指示吧，Aug 8 盘前就ER 了 |
|
D*********t
发帖数: 5748 | 49 just sold XONE, bought DDD, no idea SSYS |
|
h*****7
发帖数: 6781 | 50 my little 3, SSYS, is charming |
|
