Title:
Reading a value from a flat file to a variable?
Name:
Bruno Pimenta
Date:
2010-01-14 5:36:13 AM
Comment:
I was looking for a simple way to read a value from a flat file into a variable, without using record sets, is this possible?
Thanks,
-----------------------
Satish
You can do this by connecting the flat file task to a script, using an error connection (red arrow) and them making the script return a message, if you have trouble doing this, drop me an email at birpimenta@gmail.com
|
Title:
How to handle Exceptions
Name:
Satish
Date:
2010-01-09 4:11:26 AM
Comment:
Very good exercise. In this exercise i want to add a logic to throw a message when the flat file is not found in the source location. How to handle this. Please provide your answers to satish439@gmail.com
|
Title:
How to handle exceptions
Name:
Satish
Date:
2010-01-09 4:09:38 AM
Comment:
Very good exercise. In this exercise i want to add a logic to throw a message when the flat file is not found in the source location. How to handle this
|
Title:
Flat file source problem
Name:
Emanuele
Date:
2008-06-09 9:57:48 AM
Comment:
hi to all,
I'm working with a Flat File Source in "Fixed Size" modality, so I'd like to check prevently if the file is good formed, i'd like to check that it's a multiple of byte of a single raw..
anyone can help me? thanks
|
Title:
Adding Source Filename Column
Name:
Paul
Date:
2008-06-07 6:14:34 PM
Comment:
Thx for the article. Can you tell us, step-by-step, how to add a column to the destination table that contains the name of the source text file? TIA.
|
Title:
thanks
Name:
Ankit
Date:
2008-03-15 3:49:10 PM
Comment:
Thanks for the nice startup. I was able to transform the theory into practical.
However, i guess u should provide flat file for download, also sometime in the article it was very clear from to right click, etc.
Anyhow, thanks for the nice article.
|
Title:
Naming the file (dynamically)
Name:
Steve
Date:
2007-11-15 1:14:56 PM
Comment:
I'm not sure you can dynamically name it using SSIS GUI, however you could name it programmatically using SSIS advanced functionality.
I recommend you post your questions on http://sqladvice.com/lists/ A lot of MVP's, authors and other SQL experts that can provide assistance.
|
Title:
Naming the file (dynamically)
Name:
Will
Date:
2007-11-15 10:03:50 AM
Comment:
Is there a way one can dynamically name the file using a date stamp (day and year)?
Example: WillsFile20071114
|
Title:
Thousands of Records
Name:
Steve
Date:
2007-11-05 5:37:34 PM
Comment:
SSIS should import the records with no problems. How long it takes could depend on your data structure. If you are running into errors, I recommend you post your questions on http://sqladvice.com/lists/ A lot of MVP's, authors and other SQL gurus that can provide assistance.
Thanks,
Steve
|
Title:
Thousands of Records
Name:
Prem
Date:
2007-11-02 5:16:41 AM
Comment:
HYe peeps,
I want to know how to import flat files into sql server which consisting of thousands of records atleast with some speed
Looking Farward for the response
Regards to all
|
Title:
Fixed Length columns
Name:
Vijay
Date:
2007-09-15 6:21:05 AM
Comment:
HI, It's Fine.. But I want the same thing with fixed length columns. How to do that one. Can you help please... Thanks in advance...
|
Title:
Import
Name:
Steve
Date:
2007-08-28 2:23:18 PM
Comment:
What errors are you getting? Another resource for asking your questions are posted at the bottom of the article.
http://sqladvice.com/lists/ A lot of MVP's, authors and other SQL gurus could also provide assistance.
|
Title:
Flat File text
Name:
Gem
Date:
2007-08-28 11:28:29 AM
Comment:
Hello
data from my flat file contains a / . I would normally put " around the data and set " as the text qualifier ths however is not an option and I cannot import data with a / within it. Any suggestions.
Regards
|
Title:
Not working fro me
Name:
Steve Schofield
Date:
2007-03-15 2:33:17 PM
Comment:
I would verify you are logged into the server with SA or permissions to perform this. Also,check the windows event logs to see if there are any specific errors when you ran this process.
|
Title:
Not working fro me
Name:
SAM
Date:
2007-03-14 9:41:06 PM
Comment:
Hi,
I followed the complete procedure.But in the end it does nothing.Flat file source as wel as Data flow task turns red in the end but no data is transferred actually. Please Help.
|
Title:
Restrict duplicacy
Name:
ss
Date:
2006-08-08 2:15:04 AM
Comment:
Hi;
I am able to import data from a flat source file to sql server,but when I'm executing the packages for number of times it is transferring the same data into the database,can you tell me how to restrict the problem of duplicacy.
Thanks
ss
|
