Viewing 15 posts - 1,141 through 1,155 (of 3,232 total)
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?
August 12, 2009 at 2:09 pm
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...
August 12, 2009 at 2:08 pm
Here's a good read for you:
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/61824/
August 12, 2009 at 2:03 pm
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?
August 12, 2009 at 2:00 pm
OK, while the package is 'stuck', have you checked the DB for blocking or anything?
August 12, 2009 at 1:52 pm
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...
August 12, 2009 at 12:31 pm
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...
August 12, 2009 at 11:37 am
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...
August 12, 2009 at 11:26 am
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...
August 12, 2009 at 10:27 am
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...
August 12, 2009 at 10:01 am
Where is your TRUNCATE Table command?
August 12, 2009 at 9:42 am
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...
August 12, 2009 at 9:35 am
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...
August 12, 2009 at 9:33 am
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...
August 12, 2009 at 9:30 am
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...
August 11, 2009 at 3:42 pm
Viewing 15 posts - 1,141 through 1,155 (of 3,232 total)