Please post a screenshot of your Data Flow.

You could pre-process the file to append a line number to each line prior to processing the file with SSIS.

You could use a Transformation Script Component as mentioned to add...

johnnycash (5/16/2012)

---

Hello to all SQL Gurus!

Once again I come in search of your wisdom and guidance. I have an undetermined number of objects in DB A that have a...

ssurekha2000 (5/15/2012)

---

working with web based application i have a main table with 1000s of records

user A logs in & selects few records from main table

suppose user B also logs in...

Regarding the use of sys.sysprocesses, please do not recommend or use it for new development unless absolutely necessary. The replacement views are...

I can appreciate the proactive nature of what you're trying to do but I could suggest a different approach. Implement an OnError Event Handler at the package level that logs...

Maybe in an abstract way in that they both help us arrive at a transactionally consistent database in different scenarios, but...

DBA_Dom (5/15/2012)

---

One of our subs does something similar to what opc asking. The application creates and launches a job as the actual execution of the procedure takes way to long...

atfalatitkb (5/15/2012)

---

I probably am not understanding something here:-) but wouldn't a trigger on the source table which wrote data to the new destination table accomplish the same thing? your destination...

You can centralize the password for use by multiple packages using Package Configurations. As far as I know though there is no built-in functionality that will allow SSIS to access...

I am not picking up on the need to use dynamic sql.

WebTechie38 (5/15/2012)

---

Hello,

1) Yes, I am using a foreach container.

I have over 80 databases. For debug purposes, I need to stop when the name of the database gets to...

jitendra.padhiyar (5/15/2012)

---

opc.three (5/15/2012)

---

This is normal. When the initial restore was done it was done WITH NORECOVERY. Another option is to restore the database WITH STANDBY, but you have to provide...

The staging table to which I am referring is a new table you will create in the destination database. It's sole purpose will be to...

I am curious as to why you want to pass a parameter to a SQL Agent Job. Are you using Agent as a way to execute stored procedures asynchronously?