Solved

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

Posted on 2011-03-10
3
270 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

816 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now