No announcements
Found 3705478 threads
-
0 VotesCALL SSIS Package from a script
You can call your Package easily if you create a SQL Server Agent job that executes it without any schedule and then execute sp_start_job from within ...Answered | 3 Replies | 6178 Views | Created by Sajith S - Thursday, August 8, 2013 3:20 PM | Last reply by Andreas.Wolter - Thursday, August 8, 2013 3:44 PM
-
2 Votes
ssis package deployment
How we add the package back once the manifest is built.Answered | 23 Replies | 3680 Views | Created by Harry Jaj - Thursday, February 23, 2012 6:47 PM | Last reply by ArthurZ - Friday, February 24, 2012 3:00 PM -
1 Votes
Calling ssis package from another package in SSIS Catalog
I do not know how you say you could do it with packages in the file system.Answered | 1 Replies | 1494 Views | Created by nav_28 - Wednesday, December 4, 2013 5:13 PM | Last reply by ArthurZ - Wednesday, December 4, 2013 6:08 PM -
0 Votes
How to get PackageName of a called package from a SSIS project package with XMLNAMESPACES?
;WITH XMLNAMESPACES ('www.microsoft.com/SqlServer/Dts' AS DTS ) SELECT Proj_Name.jaap.value('.Unanswered | 2 Replies | 5171 Views | Created by NL_Jaap - Thursday, May 14, 2020 1:09 PM | Last reply by Yitzhak Khabinsky - Friday, June 19, 2020 1:42 AM -
0 Votes
calling ssis package from informatica
While we load fixed width multi byte file to table We have to call this SSIS package from informatica session with ...Answered | 1 Replies | 5545 Views | Created by miutush - Wednesday, June 16, 2010 5:25 AM | Last reply by Duane Douglas - Wednesday, June 16, 2010 5:55 AM -
0 Votes
SSIS - calling a package from an external solution
I want to call another package that is in another solution.Answered | 2 Replies | 1004 Views | Created by Yvanlathem - Wednesday, January 27, 2016 7:49 AM | Last reply by Visakh16 - Wednesday, January 27, 2016 9:33 AM -
0 Votes
Querying the ssis package to get the column information from file connections
Hi Gokhan_Varol, Please also refer to the following link, List All SSIS Packages Deployed On Your Integration Server: ...Answered | 8 Replies | 7948 Views | Created by GV1973 - Monday, August 22, 2011 5:16 PM | Last reply by Eileen Zhao - Tuesday, August 23, 2011 6:21 AM -
0 Votes
SSIS package Upgrade from 2005 to 2012
Can you try saving packages copies to different folder and then do the upgrade by including them onto a IS project?Answered | 3 Replies | 2917 Views | Created by Spunny - Wednesday, April 2, 2014 4:26 PM | Last reply by Visakh16 - Wednesday, April 2, 2014 6:44 PM -
0 Votes
SSIS package Password
Set "Protection Level" to EncryptAllWithPassword, Set the "Package Password " value. that's it.Answered | 2 Replies | 14364 Views | Created by Cidr - Thursday, September 22, 2011 9:51 AM | Last reply by Subhash.Subramanyam - Thursday, September 22, 2011 2:30 PM -
3 Votes
execute SSIS package from BizTalk
Hi, You can call a Stored Procedure within BizTalk, that calls using a xp command a package using DTEXEC or you can add a C# class ...Answered | 4 Replies | 1191 Views | Created by giri_x_w - Tuesday, February 7, 2017 4:16 PM | Last reply by Rachit Sikroria - Wednesday, February 8, 2017 2:52 AM -
1 Votes
Calling SSIS package in Stored Procedure...
How can I pass the password?Answered | 4 Replies | 4377 Views | Created by msrahman - Monday, December 12, 2011 5:40 PM | Last reply by carlo000 - Tuesday, October 14, 2014 2:04 PM -
1 Votes
Calling WS from SSIS package
Hi Enric, Make sure the server that runs SSIS packages can go to the wild web (firewall, routing rules are in place).Answered | 1 Replies | 677 Views | Created by Enric Vives - Wednesday, January 18, 2017 11:11 AM | Last reply by ArthurZ - Wednesday, January 18, 2017 2:04 PM -
0 Votes
Deploying an SSIS Package from another SSIS Package
1. use a script task and use the SSIS Object Model: http://msdn.microsoft.com/en-us/library/ms136090.aspx 2.Answered | 1 Replies | 4518 Views | Created by Shalin Kapadia - Friday, January 2, 2009 9:15 AM | Last reply by David Dye - Friday, January 2, 2009 1:15 PM -
0 Votes
Getting return value from package
Application app = new Application(); Package pkg = app.LoadPackage(PackageName, null); pkg.Execute() then check pkg.errors to see ...Answered | 2 Replies | 4182 Views | Created by rqwew - Tuesday, April 6, 2010 7:54 PM | Last reply by Da Lin - Wednesday, April 7, 2010 12:40 AM -
3 Votes
How to call package with in package ?
I think we've asked the forum dev team to see how hard it would be to disable the "propose" for your own posts.Answered | 6 Replies | 3513 Views | Created by gubs - Thursday, October 15, 2009 8:21 PM | Last reply by Todd McDermid - Thursday, October 15, 2009 11:16 PM -
2 Votes
Run ssis packages with another package
Hi, First of all it is an easy way to execute lot of packages by just running the Master package and the understanding will be clear enough as if you have ...Answered | 3 Replies | 20427 Views | Created by knra - Monday, July 15, 2013 4:19 AM | Last reply by Amit C A - Monday, July 15, 2013 4:36 AM -
0 Votes
Change owner of an SSIS package
Even now after all these years, this is still helpful as I used it to update several SSIS packages.Answered | 2 Replies | 22093 Views | Created by edm2 - Friday, September 18, 2009 7:32 PM | Last reply by Sharma Mageo - Thursday, May 14, 2015 4:34 PM -
2 Votes
How to pass parameters from Excel to an SSIS package?
2- run the ssis package by using the excel , please read ...Answered | 5 Replies | 4230 Views | Created by Brazuca18 - Monday, November 25, 2013 6:29 AM | Last reply by Brazuca18 - Friday, December 13, 2013 5:51 PM -
0 Votes
How Call SSIS package from Stored procedure and pass a parameter to SSIS package ?
Thanks Shahriar, But in my case i am going to deploy my package and then call that package with parameter.Answered | 10 Replies | 19386 Views | Created by Ishteyak ahmad - Monday, June 28, 2010 10:00 AM | Last reply by priyanka sutrave - Wednesday, June 30, 2010 6:21 AM -
0 Votes
Calling SSIS packages from a Service Broker Queue
Call an .Net exe from the external activator and from there you can execute SSIS package.Answered | 5 Replies | 17129 Views | Created by Shiva Rajagopalan - Monday, February 26, 2007 6:08 AM | Last reply by Prasoon Pathak - Thursday, August 23, 2012 3:21 PM - Items 1 to 20 of 3705478 Next ›
No announcements
