May 27, 2011 at 6:09 pm
I have a task of importing 3 different files into a datamart db table. I am new to ssis and need some help as for someone to guide me to what would be the best approach to accomplish my task. I have the following scenario:
3 different files in the following formats:
XML, XLS, CSV
Need to import them into a table with the following data types:
varchar(1) to varchar (8000)
smalldatetime
int
float
datetime
money
smalldatetime
I need to creat this in one package if possible.
It would help me a lot to know what would be the best data types (i.e. DT_I4, DT_NUMERIC, DT_STR, etc.) to map from the files to the data types in the sql table listed above.
thanks for your help
Al
May 27, 2011 at 6:35 pm
Al,
You may find better results posting in the SSIS forum, rather than SQL server 2008 newbies. You'll get more SSIS talent finding your post and answering.
Jim Murphy
http://www.sqlwatchmen.com
@SQLMurph
May 27, 2011 at 9:31 pm
Gosh, this one sounds a whole lot like homework, a test, or an interview question. 😉
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply