i******7 发帖数: 421 | 1 自己看了几本书,但是书上都是泛泛而谈,看了还是不会用。对这个SSIS完全没有经验
。平时就是写点简单的store procedure,做做data analysis。但是很想学。大家有啥
建议?
非常感谢! |
i****a 发帖数: 36252 | 2 read 10 thousand books, not as good as walk 10 thousand miles
【在 i******7 的大作中提到】 : 自己看了几本书,但是书上都是泛泛而谈,看了还是不会用。对这个SSIS完全没有经验 : 。平时就是写点简单的store procedure,做做data analysis。但是很想学。大家有啥 : 建议? : 非常感谢!
|
j*****n 发帖数: 1781 | 3 http://www.sqlshare.com/
【在 i******7 的大作中提到】 : 自己看了几本书,但是书上都是泛泛而谈,看了还是不会用。对这个SSIS完全没有经验 : 。平时就是写点简单的store procedure,做做data analysis。但是很想学。大家有啥 : 建议? : 非常感谢!
|
y****w 发帖数: 3747 | 4 去amazon买那个24小时啥的,很简单,但是能让你了解大概,能上手。其他东西可以慢
慢深化,再买professional ssis之类的慢慢进补。
在 ing63077 (ing) 的大作中提到: 】 |
g***l 发帖数: 18555 | 5 我按照录像上的IMPORT EXCEL INTO SQL SERVER,居然说我64 BIT的WINDOWS 7出错,
用FLATFILE进又说是UNICODE对不上,我靠,SSIS真难用,最后用了个IMPORT EXPORT
WIZARD FLAT FILE,还要进来做类型转换。 |
j*****n 发帖数: 1781 | 6 Jet does not work under 64bit. If you have to, you may need to obtain a
32bit version of DTEXEC.EXE in order to execute your package.
Anyway, you have to create a package under 32bit environment for Excel
import.
Data conversion transformation is very commonly used under Data Flow task.
When you having difficulty for using SSIS, do not just blame it, it only
means that you haven't get it yet.
【在 g***l 的大作中提到】 : 我按照录像上的IMPORT EXCEL INTO SQL SERVER,居然说我64 BIT的WINDOWS 7出错, : 用FLATFILE进又说是UNICODE对不上,我靠,SSIS真难用,最后用了个IMPORT EXPORT : WIZARD FLAT FILE,还要进来做类型转换。
|
g***l 发帖数: 18555 | 7 可是SERVER都是64BIT,我的PC也是64BIT,这也太弱智了吧,还要用32BIT的做IMPORT
,干脆搞成CSV算了
【在 j*****n 的大作中提到】 : Jet does not work under 64bit. If you have to, you may need to obtain a : 32bit version of DTEXEC.EXE in order to execute your package. : Anyway, you have to create a package under 32bit environment for Excel : import. : Data conversion transformation is very commonly used under Data Flow task. : When you having difficulty for using SSIS, do not just blame it, it only : means that you haven't get it yet.
|
j*****n 发帖数: 1781 | 8 JET is quit old tech... back to 1990's?
IMPORT
【在 g***l 的大作中提到】 : 可是SERVER都是64BIT,我的PC也是64BIT,这也太弱智了吧,还要用32BIT的做IMPORT : ,干脆搞成CSV算了
|
j*****n 发帖数: 1781 | 9 JET is very old tech... back to 1990's? Also if you are using Office 2003 or
lower version, I bet the program file is under C:\Program Files(x86).
IMPORT
【在 g***l 的大作中提到】 : 可是SERVER都是64BIT,我的PC也是64BIT,这也太弱智了吧,还要用32BIT的做IMPORT : ,干脆搞成CSV算了
|
j*****n 发帖数: 1781 | 10 btw, Excel is the #1 disliked file format for most ETL developers.
Regardless which ETL tool is used.
Formatted TEXT is the #1 preferred.
or
【在 j*****n 的大作中提到】 : JET is very old tech... back to 1990's? Also if you are using Office 2003 or : lower version, I bet the program file is under C:\Program Files(x86). : : IMPORT
|
y****w 发帖数: 3747 | 11 en, borrowing some function(from .Net, Perl,etc.) and write a tool to
transform excel files to csv files can be a good idea.
just develop features needed, don't try to develop some powerful common
tools, could be easier.
【在 j*****n 的大作中提到】 : btw, Excel is the #1 disliked file format for most ETL developers. : Regardless which ETL tool is used. : Formatted TEXT is the #1 preferred. : : or
|