alpesh-419376 (7/29/2010)

---

Hi,

I have job which internally executes SSIS package. the issue is when i run this job it shows executing but do not actully runs the package which is...

In other words, let's say I've got a text file with a 1,000 records and 2 of those records are bad and can't be loaded. I'd like for 998...

MostInterestingMan (7/27/2010)

---

Hello,

I have a straightforward package that uses an OLEDB Source to copy data using a query to a Flat File Connection Destination (.csv). The date field is not displaying...

As Phil mentioned this would be a flaw in the code as this event (post-execute) would get executed only for the final row in the pipeline.

You can use distributed queries but then you need to...

can you post how you are running the SSIS against sql 2000? Are you running the SSIS graph from your local machine and the connection settings pointing to the SQL...

if you have the flexibility of editing the ssis package if you need to restart the process.. then you can manually get the max value of the recordset that were...

sqlfavor (4/7/2010)

---

I have identical source databases(SQL Server) that I want to perform parallel ETL into single DW. The number of source databases can vary, so some sort of dynamic connection...

Can you check the data type of the variable "Error1"? Also is there a need to perform this inside data pump? You can do this in control flow itself and...

Is it also possible/necessary to adjust the max size of the transaction log? If yes, where can i do that?

And will this dataflow task be able to resume in case...

Questions:

- Is there a way to 'repair' the imported db? Since the data seems physically there on the hdd, and the row importing process went till 100%

- Is there a...

Did you check the checkbox that "Retain null values from the source as null values in the data flow" in the flat file connection manager?

anand_vanam (7/21/2010)

---

I am loading Data from a flat file to SQL Server Table.

I execute the package by keeping maximum insert commit size property in OLEDB destination to 0 (zero)

[OLE...

peterzeke (7/21/2010)

---

I'm trying to develop a package that first compares the record counts of two tables. If the counts don't match, then the next step is to replace the current...

The issue got resolved after running chkdisk on my laptop... It was popping up everytime when i reboot my machine.. I tried that once and the connection issue got resolved.