No announcements
-
49 Votes
FAQ - 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 | 138596 Views | Created by Phil Brammer - Monday, November 26, 2007 5:55 PM | Last reply by Zoran Ivić - Friday, November 20, 2015 12:14 PM
-
1 Votes
Exception from HRESULT: 0xC0047020
I've created an SSIS package that executes a C# application and stores the response in a string variable. I then use a Script Component to parse the string and write the data to a ...Unanswered | 8 Replies | 178 Views | Created by naomilynda - Friday, February 15, 2019 1:38 PM | Last reply by Yitzhak Khabinsky - 14 minutes ago -
0 Votes
What is the best way to eliminate duplicates?
Hello all, I have an Excel file as my datasource and i need to insert new records only to the database table ... -
0 Votes
How to pull the data from Linked server
Hello, I have question, I've task to pull the data from the script, 1st it's create TWO temp tables and data is pulling from linked server and put it into one data file like .csv ... -
0 Votes
Delete and update in different tables using SSIS package
Hi Team Have data in 3 different databases like Archive, Staging and Live. Live DB : data from Jan 2006 to Dec 2018 Archive DB ...Unanswered | 25 Replies | 668 Views | Created by BaluChalla - Thursday, January 10, 2019 12:04 PM | Last reply by Yitzhak Khabinsky - 1 hour 30 minutes ago -
0 Votes
convert from string to date
hello , please i have a trouble to convert 2 columns from string to date i tried to use querry here my step i have to put a condition on the ...Unanswered | 2 Replies | 54 Views | Created by AsmaGhattassi - 2 hours 29 minutes ago | Last reply by Yitzhak Khabinsky - 1 hour 37 minutes ago -
1 Votes
SSIS Check Dynamic Connections (Oracle, SMTP, SQL, DB2, AS400)
Good day, I found scripts to test connections and on success/failure constraints I want to determine the container execution The issue I found on web is that ...Unanswered | 6 Replies | 142 Views | Created by Ismailc1 - Sunday, February 17, 2019 9:26 AM | Last reply by Ismailc1 - 2 hours 52 minutes ago -
0 Votes
Map fields in Destination Data flow Components
Hi All, I have to map the fields of Source Component to fields of destination Component data flow. Please provide me any code sample for the ...Unanswered | 4 Replies | 64 Views | Created by Sahil CRM Developer - 6 hours 41 minutes ago | Last reply by Sahil CRM Developer - 5 hours 33 minutes ago -
0 Votes
How to create Custom Destination component?
Hi All, Please let me know, how to create Custom Destination Component for SSIS. Please provide me any references.Unanswered | 4 Replies | 45 Views | Created by Sahil CRM Developer - 9 hours 32 minutes ago | Last reply by Sahil CRM Developer - 6 hours 29 minutes ago -
0 Votes
how to set columns in Destination Data Flow Component.
how to set columns in Destination Data Flow Component. -
0 Votes
Writing Static Variable to SSIS logging file while On Error Event
Team, Anyone could suggest on writing static variable value from SSIS package to log file during 'ON ERROR' event in SSIS. As of now, we have enabled the ...Answered | 10 Replies | 212 Views | Created by karthi20 - Wednesday, February 13, 2019 2:05 PM | Last reply by Yang.Z - 6 hours 54 minutes ago -
0 Votes
توكيل صيانه كارير 01014723434اعطال تكييف كارير 01225025360 مدينه نصر
CarrierUnanswered | 0 Replies | 28 Views | Created by توكيل صيانه كارير 01014723434اعطال تكييف كارير - 7 hours 29 minutes ago -
0 Votes
[Send Mail Task] Error: Either the file "////ServerName//Transfer//Reporting//Completed" does not exist or you do not have permissions to access the file.
Expressions. I have also cleared the excel file if exist in memory using script task. I do have access to the folder location, when i checked from RUN ...Unanswered | 3 Replies | 49 Views | Created by lasiw - 11 hours 12 minutes ago | Last reply by Av111 - 7 hours 50 minutes ago -
0 Votes
Cannot acquire a managed connection from the run-time connection manager on SSDT 2017
I'm using SSDT 2017 and trying to retrieve data from a SharePoint 2013 List and loading to a SQL Server 2017. I'm using the built-in ODATA Source Connector on SSDT ...Proposed | 3 Replies | 153 Views | Created by Lester Attai - Monday, February 11, 2019 5:25 PM | Last reply by Yang.Z - 8 hours 21 minutes ago -
1 Votes
How to include header in SSIS package when export to CSV?
At the moment when I export out to a CSV file, the headers are not included. How do I include the header?Proposed | 9 Replies | 240 Views | Created by Charlie2 - Monday, February 11, 2019 8:31 PM | Last reply by Yang.Z - 8 hours 24 minutes ago -
0 Votes
Mapping columns in custom Destination component
I am working on a destination component where the columns in the destination are already set. I want to give the user the option to map columns, similar to the way the Excel destination ...Answered | 3 Replies | 7356 Views | Created by Scott Vande Krol - Tuesday, December 20, 2005 8:34 PM | Last reply by Sahil CRM Developer - 9 hours 26 minutes ago -
1 Votes
How to convert DateTime to CSV file?
This is what I currently have in my Data Conversion. And it's showing 2019-02-05 16:07:48.430000000 in the CSV file. I want to show 2/5/19 1:25 AM instead. What ...Proposed | 12 Replies | 238 Views | Created by Charlie2 - Tuesday, February 12, 2019 4:58 PM | Last reply by Yang.Z - 9 hours 27 minutes ago -
1 Votes
SSIS Package Migrated from VS 2008 to 2015 failing randomly on 1st execution only with Object cannot be cast from DBNULL to other types.
Hi Guys, This is regarding one random issue which causing the SSIS package failure in first execution and on 2nd onwards execution the issue automatically ...Unanswered | 6 Replies | 137 Views | Created by BSethi24 - Friday, February 15, 2019 5:54 PM | Last reply by BSethi24 - 10 hours 16 minutes ago -
0 Votes
Connecting to and getting Oracle data with SSIS
Hello Forum. Do I need an Oracle client installed on the SSIS machine in order to have SSIS reach out to an Oracle database to pull the ...Unanswered | 2 Replies | 103 Views | Created by bbelous - Friday, February 15, 2019 5:56 PM | Last reply by Yang.Z - 11 hours 2 minutes ago -
0 Votes
Who will be announced as the next SQL Server Integration Services Guru? Read more about February 2019 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. ... -
0 Votes
Call an SSIS Package from Access - Best way?
Hello All I need to let my users call an SSIS package from an Access application. The package will import a text file from a specified folder, into an Access table, which is ...Unanswered | 10 Replies | 8738 Views | Created by Leeroyster - Tuesday, April 27, 2010 12:05 PM | Last reply by Dan Guzman - 18 hours 7 minutes ago - Items 1 to 20 of 63939 Next ›
No announcements