[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2011-03-10
3
Medium Priority
?
282 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 2000 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

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 …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

656 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