No announcements
-
50 VotesFAQ - SSIS Information, Webcasts, Tools, Add-ons, etc...
To add to the list, simply contact one of the moderators around here, or post a reply to this thread. Microsoft Reference Material SQL ...Sticky | 39 Replies | 143147 Views | Created by Phil Brammer - Monday, November 26, 2007 5:55 PM | Last reply by Zoran Ivić - Friday, November 20, 2015 12:14 PM
-
0 Votes
SSIS Loop for SQL instances problem
I have several SSIS packages that loop to find instance permissions. The problem I am having is some of the instances that are being processed in the loop are offline so I when I run the package ...Unanswered | 4 Replies | 155 Views | Created by nickswoca - Friday, June 14, 2019 2:05 PM | Last reply by Mona Lv - 18 minutes ago -
0 Votes
Unzip selective files over network shared drive using SSIS - I need a faster way to do it.
Hi, I developed a package that uses execute process task for unzipping selective files based on their names. The SSIS package runs 6 different ForEach Loop Containers for each ...Unanswered | 2 Replies | 181 Views | Created by super_vdawg - Friday, June 14, 2019 1:20 PM | Last reply by Mona Lv - 30 minutes ago -
0 Votes
SQL Server Database Project + Windows Form Project - In a Single Solution of Visual Studio
Dear Colleagues, Being required for the first time as I seek to develop a User Interface on the Windows Form for a SQL Server Database I shall oblige you experts' advice as to ...Unanswered | 1 Replies | 85 Views | Created by Faraz A. Qureshi - 11 hours 14 minutes ago | Last reply by Simple Samples - 6 hours 10 minutes ago -
0 Votes
OData Integration with Dynamics 365 connection
Hello All , We have D365 for finance and operation on-premise environment , we need to use OData integration ,so when trying to connect to OData using the ... -
0 Votes
Running SSIS package with script component on SQL Server 2016 gives error Component Mismatch Exception
I have SSIS project deployed on SQL Sever 2016, the project has a package that uses script component, the package runs with no errors locally on VS 2017 but when deployed gives ...Answered | 6 Replies | 398 Views | Created by TANZEEL1994 - Thursday, May 30, 2019 6:42 AM | Last reply by TANZEEL1994 - 15 hours 18 minutes ago -
0 Votes
How to call SFTP using ssis script task
Hi Team, Have stored sftp data into sql table as shown in ...Unanswered | 2 Replies | 196 Views | Created by BaluChalla - Friday, June 14, 2019 3:48 AM | Last reply by COZYROC - Saturday, June 15, 2019 10:19 PM -
0 Votes
CDC for Oracle by Attunity stuck at status Logger
Hi, I have asked this question on the MSDN Server Tools forum (CDC for Oracle byAttunity stuck at status Logger), where I was advised to post in the SSIS forum, and on ...Proposed | 5 Replies | 231 Views | Created by JohnMPSC - Wednesday, June 12, 2019 2:33 PM | Last reply by ArthurZ - Saturday, June 15, 2019 8:20 PM -
0 Votes
The column delimiter for column 'xxxx' was not found
Hello, I am facing an issue "The column delimiter for column 'xxxx' was not found" in SSIS. I have imported SSIS package in MSDB of SQL Server 2014. It was working well in ...Unanswered | 4 Replies | 269 Views | Created by Rajesh Lohar - Thursday, June 13, 2019 2:26 PM | Last reply by ArthurZ - Saturday, June 15, 2019 8:17 PM -
0 Votes
dtproj cannot be opened because its project type is not supported by this version
I have SSIS packages both developed in SQL 2008 and SQL 2012 and so my system requires visual studio 2008 and visual studio 2012. I am able to open packages developed in SQL 2012 using VS 2012 in TFS ... -
0 Votes
Unpivot and Parse Columns
Hello , I have a data that is set up like this Group 1 Group 2 Group ...Unanswered | 8 Replies | 238 Views | Created by AmitSSRS - Thursday, June 13, 2019 9:14 PM | Last reply by Soumen Barua - Saturday, June 15, 2019 2:36 PM -
0 Votes
Package execution error due to version issue
Package built on - VS 2017 SQL Server Version - SQL Sever 2016 SQL Server Integration Services Version - 11.0 I am trying ... -
0 Votes
Remove Comma from String
Hello, I have a values in a column like this - SAS,No,1,136.13 GB,Online,Ok,DELL(tm),Not Applicable,6XM3MGN0,YS0D, I am taking that ...Unanswered | 6 Replies | 212 Views | Created by AmitSSRS - Friday, June 14, 2019 8:42 PM | Last reply by AmitSSRS - Friday, June 14, 2019 11:15 PM -
0 Votes
Transferring geometry data using SSIS
Hello! We need to refresh (i.e. re-copy) a table in a database in one instance of sql with a copy of the same table in another instance, using SSIS. The only ... -
0 Votes
Lost lineageID mapping after upgrading SSIS 2008 to 2016 in data conversion task
After upgrading seems like lineageId gets incorecctly mapped (or not changed for output) in "data conversion" task. Error is "cannot find input column with lineage id ...which is needed ... -
0 Votes
SSIS - Flat File Connector Not Recognizing CRLF in Header
Good afternoon. I could use another brain on the below issue: I need to import a file with 4 different data types in it. I'm working just on the second ... -
0 Votes
receiving streaming data in ssis
Hi I run developer 2017. short of finding a way (if its even possible) to plumb power bi to a new streaming data source, what are my options in ssis for targeting a local or azure sql db to ... -
4 Votes
DatabaseBackup
On SQL Server 2012 Version I was trying to create a package to perform regular backup and archive of databases on my server. I have created a table to ...Answered | 10 Replies | 464 Views | Created by Neilcse - Sunday, February 19, 2017 4:42 PM | Last reply by Neilcse - Friday, June 14, 2019 2:02 PM -
0 Votes
Getting data from Package XML
Hello I have 2 questions … The code below (Thanks Yitzhak), returns a packages task and connection manager, how do I return the contents ...Answered | 5 Replies | 190 Views | Created by ryand09 - Thursday, June 13, 2019 10:35 AM | Last reply by Yitzhak Khabinsky - Friday, June 14, 2019 1:55 PM -
2 Votes
DBTYPE_I4
I am getting the below error when I try to insert the system variable values ErrorCode and ErrorDescription into Audit table in Event handling part of SSIS [Execute SQL Task] Error: ...Proposed | 5 Replies | 2306 Views | Created by Neilcse - Tuesday, February 21, 2017 7:53 AM | Last reply by Neilcse - Friday, June 14, 2019 1:55 PM -
0 Votes
Environment reference Id: NULL. error while executing the job
Hi i'm getting an error while executing the job in sql server : nvironment reference Id: NULL. Description: Execution Timeout Expired. The ...Unanswered | 8 Replies | 290 Views | Created by lokesh raghav - Monday, June 10, 2019 10:12 AM | Last reply by Mona Lv - Friday, June 14, 2019 10:28 AM - Items 1 to 20 of 64532 Next ›
No announcements
