1. You can use variables in SSIS , and can also assign values to it from your asp code. This article might help you :

http://msdn2.microsoft.com/en-us/library/ms140216.aspx

You can use "for...

Okay Great ! , you can post your queries here as it will be benefitial for everyone who uses this community , you can mail me on priteshpatel2205@gmail.com as...

i think i got your problem. Your file format is "ragged right" . Use this format instead of "Fixed width" , you will have a better view of data in...

i am assuming that you have a fixed file with no delimiters, and you want to separate the data in different columns, you can do this by following these steps:

1....

can you attach some sample data in a file here so that i can understand your problem

You can use WMI task with the following WQL query to watch a folder or a particular file .....

FOR INDIVIDUAL FILE :

SELECT * FROM __InstanceCreationEvent WITHIN 60...

BULK INSERT task will be ebst suited if you do not want to carry out any transformation.

You can use the below written script . Also , you can use the SQL Query in the execute sql task as well , i didnt have the time to...

I think you need to set the colulm delimiter correctly.Edit the file connection manager. In the columns tab in the file connection manager ---> edit, you beed to first "reset"...

There can be a number of ways to achieve this, the basic idea should be to lookup the incoming filename against the ones that are stored in the table and...

You can try using a configuraion file or save the configuration in a table. This post might help you.

http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm

http://www.sqlis.com/26.aspx

You can do it by enclosing all your control flow tasks into the "sequence container" then connect a send mail task to the sequence container. You can configure to fire...

Hi,

I assume that you are able to set up the for each loop container successfully and are able to read the file names into variable. I have attached...

Heres what you can do :

1. use a for each loop container, in the "collection" tab ,use ForEach File Enumerator" option.

2. On the same tab you will have "expressions" ,...

Hi ,

I am giving the code of a function that will retrieve the column name giving the error. The idea behind achieving this is to...