Viewing 15 posts - 1 through 15 (of 85 total)
bteague (12/4/2015)
Sorry. I couldn't release the package outside of our organization.
The error occurs when you run the script for packages not of 2012 version. Please can you migrate your packages...
--Divya
December 6, 2015 at 3:54 am
pchelptx (12/4/2015)
--Divya
December 4, 2015 at 11:38 am
pchelptx (12/3/2015)
Where you able to run this in SSIS 2008?If so would you share how you did it?
The XML code behind of SSIS pkg slightly differs in 2008. I have...
--Divya
December 3, 2015 at 8:33 pm
bteague (11/30/2015)
It would appear so. The last run populated PackageXML for the 60 rows that were generated.
Can you send me one package?
--Divya
November 30, 2015 at 10:51 pm
bteague (11/30/2015)
I'm not sure how you determine this. We're using the VS 2010 shell distributed with SQL Server 2012.
This should work. Can you please check if the package xml is...
--Divya
November 30, 2015 at 10:41 am
bteague (11/25/2015)
...
------------------------Get all variable details-------------------------------------
Msg...
--Divya
November 26, 2015 at 5:22 am
bteague (11/24/2015)
--Divya
November 25, 2015 at 11:08 am
corey lawson (9/1/2015)
--Divya
September 3, 2015 at 3:59 am
Misha_SQL (9/2/2015)
--Divya
September 3, 2015 at 3:58 am
Phil Parkin (9/1/2015)
I have only skimmed the article so far, but one question which came to mind relates to project-level parameters.
As these are not part of the package DTSX,...
--Divya
September 1, 2015 at 5:19 am
Phil Parkin (9/1/2015)
I have only skimmed the article so far, but one question which came to mind relates to project-level parameters.
As these are not part of the package DTSX,...
--Divya
September 1, 2015 at 5:15 am
hr_sn (8/31/2015)
Great article Divya!Cheers!
Thanks for liking..hope it helps you.
--Divya
August 31, 2015 at 11:35 pm
Andy, I have used BIML in one of my project to create a package dynamically. The script created was using xquery of sql server to generate Biml code by fetching...
--Divya
August 13, 2015 at 10:32 pm
If your sp parameter name is always same as the table column named, the query below can be helpful.
select o.name,p.name as paraname,p.max_length as paralength, t.max_length, OBJECT_DEFINITION(o.object_id) Spdef
from sys.objects o
join...
--Divya
July 1, 2014 at 5:14 am
kapil_kk (6/30/2014)
I have a scenario in which I need to capture count of rows returned by execution of stored procedure.
I new we can do it declaring OUTPUT parameter to...
--Divya
June 30, 2014 at 3:51 am
Viewing 15 posts - 1 through 15 (of 85 total)