Did u used the same file for child packages too?

taking a guess?

Use script task, using for each file collection .. you can do this...

get all files using system.io from folder A

Take a file into variable

If not file exists in folder C...

We really dont need foreach task to do this, all the steps can be done in single scrit task using for each file collection...

get all files using system.io

compare modified date,...

yes, you can use script task to read the file name / ( for each task), and take last 3 digits of the file name (not extension 🙂 ), then...

No, in such cases you cant use config files,

Let us know, how you are getting random number, who generates for you? or you are the one who generates it?

you can...

use configuration file, which will read dynamic values, you can modify any time.

or use one table to store these two values and retrieve into variables using execute sql task code,...

how does SSIS understands how many columns/data types in customer file or dept file, you must create a separate DFT's for each flat file if layout is not same.

its same...

Check below link on ...How to add NULL Defense to your SSIS packages using scripting

it might help you

http://www.mssqltips.com/tip.asp?tip=2044

if you see the connectionString property of the database connection, you will see some thing like this...

Data Source=MyServer;Initial Catalog=myDB;Provider=SQLNCLI10.1;Integrated Security=SSPI;Auto Translate=False;....

Take that string and replace server and database ( if...

Define Database/username/password variables in configuration files ( configuration files are same with diff values for both environments), and build an expression for connectionString property of a SQL connection. thats it...

Cheers

Sounds good, glad to hear that issue was resolved with...

try...some thing like this...

SUBSTRING( «character_expression», 1, 1 ) >= 0

&& SUBSTRING( «character_expression», 1, 1 ) <=9

&& SUBSTRING( «character_expression», 2, 1 ) = "_"

&& SUBSTRING( «character_expression», FINDSTRING( «character_expression», «string»,...

1. you can use CONVERT function, to convert date both the sides to same style like this...

status_code = ?(variable) and convert(varchar(10),[Created Date],112) = convert(varchar(10),?,112) (variable)

2. to change date / status,...

you can send output via send mail task, howerver you need to create output of that command to a file, attach file in mail task as attachment.

without attachment, i guess...

evelyn.bidenkova (7/15/2010)

---

HI - I seem to have similar problem - when importing data from FLAT txt file to table in SQL Server via .dtsx file empty records in txt are...