Get data into SQL with SSIS...what the heck?

The file below is fixed width.  I want to bring it into a SQL Server 2005 table, but I can't seem to figure out how to make that happen using an SSIS package (need to automate the job).  I used to use DTS packages in SQL 2000 (very limited experience in any of this), and it was no problem to just use Copy Column and go by choosing the format of the input file....I seem to be missing that in SSIS.  HELP PLEASE!!!!

Cheers,
s032-extract-PRD.txt
Import-Specs.bmp
dabdowbAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
Open SQL 2005 SSMS (Management studio), expand your databases, right click the one where you want to import into then select Tasks->Import Data a wizzrad pops up and follow the steps there. Plese note whatver file you want to import is relative to the SQL Server Box where you do the import not your local workstation. Also when you are close to finish instead of run now you can save it as SSIS package.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dabdowbAuthor Commented:
It took a little tweaking to get the system to bring the data in, but I did get it to work.  I do have one more question..I'll post in the forum though.  Thanks.
0
dabdowbAuthor Commented:
What I am curious about is, why SQL will not let me specify how the data should load into the table...I had to conform to it.  For instance, in this data set, the last two columns are supposed to be dates.  They are in the format of yyyymmdd in the file, but when I chose Date as my type for the destination table, it was having nothing to do with it.  I finally just had to bring it in as a string.  I'll need to figure out how to turn it into a date now that it is in the database, but that is a whole different question I am sure.  Thoughts?
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.