No announcements
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky1VotesAre you a technology guru? Show us your solutions and become the Integration Services Guru for June 2013!!
TechNet Wiki is looking for and celebrating the best of the best! Is that you? Do you consider yourself an expert or authority on SQL Server Integration ... -
Sticky40VotesFAQ - 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 ...
-
Answered0VotesCompress Zip File with SSIS
With standard SSIS tools (without having to download/install anything), can some one tell me what steps I need to take to compress/zip an excel file? I want to take this file, ... -
Unanswered0Votesmsgbox not opening when error found
Microsoft.SqlServer.Dts.Runtime.DtsRuntimeException: The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container ... -
Unanswered0VotesSISS 2008 R2 - Copying Files from Mapped Network drive to local using File System Task
Hi Server A - standalone server Sever B - SQL server I have mapped a network drive (Z:) from Server A in Server B and successfully copied ... -
Unanswered0VotesData Flow Tasks Deadlocking each Other
Hi Experts I am using a SSIS package that does the following task - and Retain Same Connection is Set to TRUE A) Execute SQL Tasks - BEGIN ... -
Answered1Votescall a ssis package
I have a sqlcmd file that is used to load and create a database schemas including tables, view, function etc. At the end of the file, I would like to call to run a SSIS package. ... -
Unanswered0VotesSSIS 2008 Oracle 11g On 64 bit Linux
I am completely new to SSIS. I am sorry if I am stupid with questions I am not able to connect to Oracle Database using connection manager in SSIS 2008. I ... -
Unanswered0VotesPopulate project level connection manager parameter in SSIS 2012
I have a list of connection string values stored in a table. I want to be able to populate the project level connection string parameter with one of these values from that ... -
Unanswered4VotesValidate URL format in a column - SSIS
Hi, I have a table with 4 columns. One of them contains URLs. Is there a way to validate the URL format in SSIS and have two outputs, one output will have ... -
Answered2VotesDTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER
All, I’ve come across an issue with a newly created package. Several error messages are receved relating to the package's connection ... -
Unanswered0VotesMysql to Ms Sql 2005 - Linked Server query select query
I created Linked server in Sql server 2005 and tried Data Migration from MySql to MS Sql 2005 but some of the data got rejetced and i need to find out that which data got ... -
Unanswered0VotesProtocol error in TDS stream
I am trying to import this huge table from a different server and regularly getting this error. I checked online for this error dint get any fix for ... -
Unanswered0VotesFor loop inside For Loop (Nested For Loops)
Hi, I have sequence container, in which there are nested loops. When i execute the container it works fine (it loop thru each year and each Year Month), but when execute the ... -
Unanswered0Votesdata flow task- task not completing (not changing from Yellow to Green)
I am using data flow to get data from a source and loading that into a destination. There are 6k rows in source, after running the job 6k rows gets loaded ... -
Unanswered0VotesRenaming the file with File System Task
The below expression is working fine and I am getting the Date with File name. @[User::SourcePath] + (DT_WSTR, 100) (DT_DBDATE) GETDATE() + SUBSTRING( ... -
Unanswered0VotesNot able to browse to shared network path
> add a network location) but still that drive doesn't appear. I'm using Windows 7. Any ... -
Unanswered0VotesSSIS Match 1 field, append other
So I am going from an Excel file to OLE DB Destination. MY Excel file has a ID_Number and Resolved_Date. I need to look for a matching ID_Number in the destination and if there is a matching number ... -
Unanswered0VotesSQL server linked server error while integrating with odbc driver
Hello We are using MSDASQL (Microsoft oledb provider for odbc drivers) and our own odbc driver to testing below scenarios 1) using Rowsetviewer ... -
Unanswered0Votes/Conn in command line to override config location
dtexec /f "u:..." /Conn {my guid};"my override path" but I keep getting an error basically saying the connectiion "{my guid}" is not found. ... -
Unanswered0VotesMoving files to different folders and adding a date folder at th same time
Hi there, Ive managed to get the following working. I have files with Services within the file names, _SEN_, _EP_ , _FSM_ ... -
Unanswered2Voteserror in package
Hi all, My package giving me this error. Can anyone give me brief insight about this.. " An error occurred while assigning a ... - Items 1 to 20 of 47318 Next ›


