No announcements
Found 1935476 threads
-
0 Votesregarding ssis - changing source, how to adjust destination
you need to create it outside SSIS by connecting to SSMS and using query as below ALTER TABLE <TableName> ADD <ColumnName> <datatype> <NULL|NOT ...Answered | 3 Replies | 1123 Views | Created by Koteswararao Bellam - Tuesday, February 4, 2014 10:49 AM | Last reply by Visakh16 - Tuesday, February 4, 2014 12:35 PM
-
0 Votes
Regarding SSIS - send these sources into different destinations
Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com |Answered | 7 Replies | 1724 Views | Created by Koteswararao Bellam - Monday, July 29, 2013 6:58 AM | Last reply by SSISJoost - Tuesday, July 30, 2013 5:20 AM -
0 Votes
Multiple source to one destination in ssis
But union like naveen mentioned does the job to 'join' them verticallyPlease mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com ...Answered | 2 Replies | 1981 Views | Created by Sharma.C - Thursday, March 7, 2013 6:32 AM | Last reply by SSISJoost - Thursday, March 7, 2013 7:57 AM -
0 Votes
one source 3 destination in SSIS
Then you need to read that column insert the table name into a variable and perform in the OLEDB Destination INSERT INTO @@User::TableName or something.Answered | 2 Replies | 1064 Views | Created by Vipin jha - Monday, January 20, 2014 4:54 AM | Last reply by Uri Dimant - Monday, January 20, 2014 6:19 AM -
0 Votes
sftp source/destination in SSIS
You will either need to hand-code this yourself using a Script Task, acquire athird party SFTP task for SSIS (I think they're all commercial), or use an Execute Process Task to run ...Answered | 2 Replies | 3588 Views | Created by joshi_sgsits_hotmail.com - Tuesday, September 20, 2011 3:57 AM | Last reply by Sharp Wang - Wednesday, September 21, 2011 9:26 AM -
0 Votes
SSIS update destination same like source dynamically.
Update data means complete data same as source(if there is change in source and same change destination but only in table ...Answered | 5 Replies | 1059 Views | Created by Yogesh Jumani 007 - Wednesday, February 10, 2016 7:03 AM | Last reply by Visakh16 - Wednesday, February 10, 2016 9:34 AM -
0 Votes
SSIS Source change from Ado.net to oracle Source
we are also using Attunity to use oracle source/destination.Answered | 3 Replies | 1095 Views | Created by Akhil_G - Thursday, June 2, 2016 4:34 AM | Last reply by ArthurZ - Monday, June 6, 2016 11:33 PM -
0 Votes
Dynamically Map source and Destination table in SSIS Package
Thanks Sir for feed back but its not like that this is dynamically changing of source and destination table.Answered | 14 Replies | 22928 Views | Created by ABHISHEK PARIHAR - Tuesday, August 7, 2012 5:00 AM | Last reply by Kay Lwin - Friday, June 29, 2018 4:35 PM -
2 Votes
converted date source to destination fails in ssis, not in ssms
At one time that ssis source select had only '1/1/1900' hardcoded for that column.Answered | 4 Replies | 897 Views | Created by db042190 - Friday, September 29, 2017 12:45 PM | Last reply by db042190 - Friday, September 29, 2017 3:14 PM -
0 Votes
How adding a data source-data destination inside SSIS 2012-SSDT
In fact, I've already tried to select the "Source Assistant" voice in the "Favorites" tab of the SSIS Toolbox, and then create a new ...Answered | 2 Replies | 1436 Views | Created by pscorca - Thursday, April 3, 2014 2:15 PM | Last reply by pscorca - Thursday, April 3, 2014 7:59 PM -
0 Votes
one source to two destination
Youtube - How to use multicast transformationYet another tutorial Hope this will help :)Answered | 1 Replies | 883 Views | Created by sourises - Thursday, November 7, 2013 5:37 AM | Last reply by Anuj Tripathi - Thursday, November 7, 2013 10:18 AM -
0 Votes
SSIS Multiple destinations
Conditional split would be asynchronous and pass on the records to destination as they come in the flow.Answered | 4 Replies | 5545 Views | Created by SQLdisciple - Friday, January 15, 2010 3:52 AM | Last reply by SSISJoost - Sunday, December 19, 2010 9:04 PM -
0 Votes
SSIS Custom components in ToolBox-How to determine Source /Destination Component
But in SQL Server 2005 wherever i select the position in toolbox,it will go and add the Souce component in Source Position,and Destination component in Destination position.Answered | 4 Replies | 3859 Views | Created by Seenajan2 - Monday, August 9, 2010 8:43 AM | Last reply by Darren Green SQLIS - Wednesday, August 11, 2010 8:19 PM -
1 Votes
SSIS Destination help
Thank youRegardsRaghuAnswered | 11 Replies | 3032 Views | Created by RP Reddy - Friday, October 9, 2009 9:28 AM | Last reply by RP Reddy - Friday, October 9, 2009 1:34 PM -
0 Votes
get table name and schema name of the source and destination in ssis package
duplicate ofAnswered | 3 Replies | 2413 Views | Created by RamarajuC - Tuesday, October 6, 2015 7:23 AM | Last reply by Visakh16 - Tuesday, October 6, 2015 8:06 AM -
1 Votes
SSIS- Advantage to set ValidateExternalMetadata to False in OLE DB Source and Destination
Hi lva2290, Someone explained the property: Most SSIS components which interact with an external system (for example, the Lookup Transform, or ...Answered | 1 Replies | 12338 Views | Created by Iva2290 - Tuesday, December 5, 2017 8:36 AM | Last reply by Pirlo Zhang - Tuesday, December 5, 2017 8:44 AM -
0 Votes
excel destination data with formula in ssis
regards afzal.Answered | 6 Replies | 10949 Views | Created by md afzal - Thursday, March 8, 2012 7:02 AM | Last reply by waqaramin - Wednesday, April 25, 2012 12:31 PM -
3 Votes
Source Tables issue in SSIS
If you want to have the package adjust to changes dynamically then you need to generate (or regenerate it) upon each change in metadata programmatically.Answered | 5 Replies | 952 Views | Created by BHVS - Monday, January 5, 2015 2:00 PM | Last reply by Koen Verbeeck - Tuesday, January 6, 2015 9:39 AM -
0 Votes
Changing destination database for SSIS Package
What I don't get though is how to punctuate the connection string.Answered | 10 Replies | 11621 Views | Created by Hugor - Friday, February 23, 2007 6:43 PM | Last reply by Mr Sean - Wednesday, January 13, 2010 2:23 PM -
0 Votes
SSIS Copy Schema and data from Source to destination
SCD wizard is for detecting changes in the data, not in the metadata.Answered | 3 Replies | 3336 Views | Created by Rohitz - Wednesday, January 25, 2012 10:05 AM | Last reply by Koen Verbeeck - Wednesday, January 25, 2012 10:50 AM - Items 1 to 20 of 1935476 Next ›
No announcements
