Nice question. Learned something about HAVING.

I think the problem lies in the fact that you can't configure an Excel Source dynamically.

Each time that you change the sheet name, the metadata changes and SSIS can't handle...

My question was, how do you want to capture it?

Do you just want to read it? Do you want to write it to a file? To a table? To be...

Well, if you use the Script Task that I gave as an example, you can write your own custom log entries.

And you failed 😉 😀

I believe the poor chap had a terrible job interview and that he has posted the questions he...

If I use Execute SQL Tasks to force a transaction, I use the following commands:

BEGIN TRAN (at the beginning)

and

COMMIT (at the end).

Make sure the connection manager to your database has...

Do you need the data in a table or do you just want to view the data?

ps: your caps lock is broken

Can't you put the DB Name in the string that you log?

Great question, but hard to read. 🙂

No, the version is important because the .NET code...

Colin Betteley (6/2/2010)

---

I believe that is what I have.

Each Task is speparate having its own SELECT clause and own connection manager to each server. The only connection between the tasks...

Strange, this works at my system:

declare @test smalldatetime;

select @test = CONVERT(char(8),19010101);

print @test

Is it only for the date...

Are you working with SSIS 2005 or 2008?

I know you can do the following in 2008:

Try

' Test here for the space in the name and put all your other code...

imani_technology (6/1/2010)

---

Thanks, that helps me to retrieve the proper number. However, I'm still confused on how to assign that result to a variable so that I can eventually add...

stewartc-708166 (6/1/2010)

---

Why execute as type os command?

a SQL job can execute a step of type "SQL Server Integration Services Package", irrespective of whether the package is stored in SQL Server...