Viewing 15 posts - 5,776 through 5,790 (of 13,874 total)
I assume that you are using sp_start_job to start the Agent job?
If so, the fact that it returns 'success' means only that the job was started successfully. It...
March 23, 2017 at 8:08 am
March 22, 2017 at 12:40 pm
March 22, 2017 at 12:25 pm
March 22, 2017 at 11:08 am
I'm developing SSIS packages for SQL 2012, and using Visual Studio to deploy the solution...
March 22, 2017 at 7:23 am
This, maybe?
IF OBJECT_ID('Tempdb..#SourceTable') IS NOT NULL DROP TABLE #SourceTable
CREATE TABLE #SourceTable ([VMID] INT, [VM_NAME] VARCHAR(100), [FIELD_NAME] VARCHAR(100), [FIELD_VALUE] VARCHAR(100))
INSERT INTO #SourceTable ([VMID], [VM_NAME], [FIELD_NAME], [FIELD_VALUE])
March 21, 2017 at 5:52 am
need your briliant minds, sadly i dont have one 🙁 and sorry for the...
March 20, 2017 at 5:19 pm
March 20, 2017 at 12:59 pm
It depends on how your application works, however whichever method you use as a general...
March 20, 2017 at 5:31 am
March 19, 2017 at 11:19 am
Sounds like you've done everything within reason to make this work.
If you have the package deployed to SSISDB, have you looked at its 'All Executions' report to see...
March 17, 2017 at 1:06 pm
This is not quite clear from your post: did you try running the Agent job in 32-bit mode? (Link)
March 17, 2017 at 12:38 pm
March 17, 2017 at 11:30 am
If you're going to publish something in English and your English is dodgy, ask someone capable to proofread it for you first.
This way, everyone is happy, ambiguities and...
March 17, 2017 at 11:24 am
March 17, 2017 at 11:12 am
Viewing 15 posts - 5,776 through 5,790 (of 13,874 total)