No announcements
-
1 VotesDo you be announced as the next SSIS Guru? Read about TechNet November 2018 competition!!
What is TechNet Guru Competition? Each month the TechNet Wiki council organizes a contest of the best articles posted that month. This is your chance ...
-
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 | 136781 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
Non-SysAdmins have been denied permission to run DTS Execution job steps without a proxy account. The step failed.
Unanswered | 2 Replies | 41 Views | Created by ashwan - 3 hours 11 minutes ago | Last reply by ashwan - 1 hour 45 minutes ago -
0 Votes
how to Re-Execute task till some condition met in SSIS 2010
0 then i want to re-execute For Loop container. this execution should happen till all the desired records marked as processed. i added a sql task to get the count of unprocessed ...Proposed | 4 Replies | 61 Views | Created by Narendra Reddy Vajrala - 23 hours 39 minutes ago | Last reply by Yang.Z - 2 hours 15 minutes ago -
0 Votes
Migrated Vs 2008 SSIS package to VS2012 and getting error while opening the Packages
Hello team, i have done upgraded VS2008 to VS2012, And while opening master packages i am getting below error for all individual packages .and this SSIS packages using config files ...Unanswered | 1 Replies | 36 Views | Created by Ravishukla20 - 20 hours 19 minutes ago | Last reply by Yang.Z - 2 hours 42 minutes ago -
0 Votes
SSIS Variable folder + filename in multiple Connection Managers
I'm looking for some help setting up a "variable + filename" setup in connection manager for a large number of files. Currently I have a SSIS package that runs through the ...Proposed | 2 Replies | 41 Views | Created by lemming3k - 19 hours 9 minutes ago | Last reply by Yang.Z - 3 hours 15 minutes ago -
0 Votes
Sharepoint connection manager not visible in Add SSIS Connection managers
Hi, I had installed sharepoint list adapters to SSDT 2012. Sharepoint List Source and Sharepoint List Destination components got successfully added in Dataflow toolbox. However when ...Proposed | 2 Replies | 92 Views | Created by Bhanu Garikipati - 15 hours 9 minutes ago | Last reply by Yang.Z - 3 hours 20 minutes ago -
0 Votes
SSIS - "Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object '<tablename>'. The duplicate key value is <1234>. Though there are no duplicate records.
Hi, I am providing support to one of our clients, where we have jobs scheduled to load the data from the tables in the source database to the destination database via SSIS packages. ...Unanswered | 4 Replies | 1612 Views | Created by Bala Murali Krishna Medipally - Tuesday, April 28, 2015 9:19 AM | Last reply by Sasmit Sharma - 3 hours 24 minutes ago -
0 Votes
Date Conversion from SQL to a .csv file
We are doing an explicit conversion in our SQL Stored Procedure CONVERT(VARCHAR, [#TempTable_Inventory_History].[ExpirationDate], 112) AS [Lot Expiry Date], And ...Unanswered | 1 Replies | 40 Views | Created by ITBobbyP - 10 hours 28 minutes ago | Last reply by Yang.Z - 5 hours 42 minutes ago -
0 Votes
how to loop iterate for loop for 5 hour in ssis
Hi I have one doubt in ssis, how to run forloop for 5 hours from execution time using for loop container in ssis initial expression ...Unanswered | 1 Replies | 41 Views | Created by JAIPAL654 - 6 hours 56 minutes ago | Last reply by Yang.Z - 6 hours 12 minutes ago -
0 Votes
SSIS and Integration service catalog packages
Unanswered | 7 Replies | 125 Views | Created by ashwan - Tuesday, November 13, 2018 7:17 AM | Last reply by Yang.Z - 6 hours 34 minutes ago -
1 Votes
Move Files to Archive Folder
Hi everyone, I have an ssis package that loads data to different csv files. The package dynamically create new files for each of the destination csv everyday. This works fine but I ...Proposed | 3 Replies | 85 Views | Created by lilutchay - Wednesday, November 14, 2018 10:56 PM | Last reply by Yitzhak Khabinsky - 8 hours 35 minutes ago -
0 Votes
How dynamically fetch cell range data from excel source in ssis?
Hello Team, I have data from pivot table in excel sheet. My header is on Sheet1$A5:D5. and all values are in Sheet1$A5:D6-D230000. But cell range is not ...Unanswered | 1 Replies | 35 Views | Created by Brijesh Kr Yadav - 12 hours 51 minutes ago | Last reply by Yitzhak Khabinsky - 10 hours 25 minutes ago -
0 Votes
Load multiple flat file on multiple folders with SSIS
>>>> C:\\Main Folder\SubFolderA\ >>>>>>>>>C:\\Main ...Unanswered | 10 Replies | 2287 Views | Created by Bambang Priantoro - Monday, February 22, 2016 1:58 AM | Last reply by Miket64 - 11 hours 7 minutes ago -
0 Votes
SQL 2014: SSIS Fails After SP3 Update
I have a 3rd party SSIS JOB running on one of our SQL server. Prior to SQL SVR 2014 SP3 (from SP2 CU12) update, it was running just fine every hour. After the update this morning, the job has been ...Answered | 3 Replies | 78 Views | Created by ARPRINCE - Wednesday, November 14, 2018 5:49 PM | Last reply by ARPRINCE - 11 hours 31 minutes ago -
1 Votes
Lookup Question
Details The customer only wants to bring in Header records going back, say, 90 days. So I have a date limiter on the header set There is ...Proposed | 1 Replies | 45 Views | Created by Devin McMahon - 14 hours 48 minutes ago | Last reply by Devin McMahon - 14 hours 15 minutes ago -
0 Votes
End of support for Business Intelligence Studio installed as part of SQL Server 2008R2
Visual Studio went out of support in April 2018 Extended support for SQL server 2008R2 finishes in July 2019 Business Intelligence development studio (BIDS) ...Unanswered | 5 Replies | 106 Views | Created by inky38 - Tuesday, November 13, 2018 4:40 PM | Last reply by Yang.Z - 22 hours 37 minutes ago -
3 Votes
SSIS 2008 R2 64-bit accessing Excel on remote server succeeds when run from SSIS, but fails when run from SQL Server Agent
I have reviewed a lot of the Forum discussions and referenced documentation on how to run SSIS on 64-bit machines and have an Excel source for the incoming data. I have tried a number of the ...Unanswered | 4 Replies | 7297 Views | Created by Grant at HP - Wednesday, March 2, 2011 1:05 AM | Last reply by Mario Nunes - 22 hours 49 minutes ago -
0 Votes
How to create connectiion manager to REST api
Hi All, I need to create a connection manager to access a REST api on a remote server. I have the static IP of the server. I am expecting I need to create a ...Proposed | 3 Replies | 60 Views | Created by rpfinnimore - Wednesday, November 14, 2018 7:52 PM | Last reply by Amit-Tomar - Thursday, November 15, 2018 7:16 AM -
0 Votes
Failed to decrypt an encrypted XML node.
Hi I deployed a SSIS 2012 project and I received the following message: How can I solve this message?Unanswered | 2 Replies | 57 Views | Created by neonash - Wednesday, November 14, 2018 3:35 PM | Last reply by Yang.Z - Thursday, November 15, 2018 7:06 AM -
1 Votes
Import from each xml file of a folder
I have multiple xml files in a folder. I need to import data from each file to its corresponding table in my database. How can I achieve this with SSIS project? please help.Proposed | 2 Replies | 79 Views | Created by Curendra - Thursday, November 15, 2018 4:27 AM | Last reply by Visakh16 - Thursday, November 15, 2018 6:16 AM -
1 Votes
Deployed package execution in SSISDB shows success but write action never happened
I simplified the issue to a simple write action in C# script task, writing current time stamp into a text file located on the same machine in C:\test\, the directory has been ...Answered | 3 Replies | 105 Views | Created by Mike_YZ - Tuesday, November 13, 2018 6:59 PM | Last reply by Mike_YZ - Wednesday, November 14, 2018 7:43 PM - Items 1 to 20 of 63560 Next ›
No announcements
