Oh, and as far as auditing new changes in your old system, can't you run a SQL trace to capture the INSERTs/UPDATEs/DELETEs?

There is not an out-of-the-box solution for you. You can build your migration out in SSIS or just script it in T-SQL. Regarless of the method, you'll be...

Here's a good read for you:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/61824/

What do you get in SSMS when you run this:

SET FMTONLY ON

exec [dbo].[UM_AuthReporting_DLFormat] 510,25,'','B',-1,1,'8/10/2009 12:00:00 AM','8/10/2009 12:00:00 AM','X','G',1,-1

SET FMTONLY Off

What is your SP doing?

OK, while the package is 'stuck', have you checked the DB for blocking or anything?

What else are you doing in your control flow? Have you tried to create a container, put the truncate command and data flow into it and set the transaction...

Haythem.Al-Kishtaini (8/12/2009)

I have a similar issue to resolve i.e if no file, then send an email.

I have created my package variable (as int32) but am unsure as to what task...

Thanks for the feeback.

Just another comment on using the view to get the message into a SB queue. Your concern with the first option is why I...

Well, from what you've just described, Service Broker may be your best friend. If you need to track real-time or near-time inventory and other things, a message based service...

Late last year, I was tasked with taking an OLTP database that had become a combination OLTP/OLAP reporting database and creating a way to run the OLTP application against it...

Where is your TRUNCATE Table command?

Keep in mind that the package itself is a container. If all you have in your control flow are those 2 tasks and you want both of them to...

Building off of the previous example:

DECLARE @ContactTable TABLE(

Date char(11) NULL,

Job varchar(100) NULL,

Telephone varchar(100) NULL,

Company nvarchar(255) NULL

)

INSERT INTO @ContactTable

SELECT...

Well, a business key would not be something that you'd need to add to the parent table. I asked if you had one, meaning, is there a natural or...

Yes, but where in the control flow will depend on how large you want to scope the transaction. You wouldn't just put it on the Truncate task. You...