Solved

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

Posted on 2011-03-10
3
273 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 40

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

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

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

Suggested Solutions

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

749 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