Solved

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

Posted on 2011-03-10
3
271 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:dabdowb
  • 2
3 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 35099940
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
 

Author Closing Comment

by:dabdowb
ID: 35100309
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
 

Author Comment

by:dabdowb
ID: 35100356
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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

792 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question