Tag Info

New answers tagged

1

I know this was asked a while ago, but maybe someone else will stumble across this answer and not spend the multiple hours that I've been bashing my head against this. Turns out that you need to use the SQL_WVARCHAR type for Variables. The following is my evidence, showing the SQL_WVARCHAR works. OLEDB command from SQL Profiler: exec sp_executesql N'exec ...


0

@Fulproof: If the article linked by @RicardoBalda is right (and it certainly seems to be) then SSIS must be installed and running for anyone to even want to export maintenance plans, because maintenance plans are SSIS packages. The instructions given worked for me, and seem to make complete sense. To address @JNK's point, what the linked article actually ...


3

That is correct. Forward compatibility is guaranteed. Backwards compatibility does not exist*. Having 4 different BIDS/SSDT instances on a machine is a pain I've known all too well but there's not much you can do. There are ways of constructing SSIS packages such that your solution can target whatever version of SQL Server will be hosting them but that's ...


1

I have used 2 tools to perform Oracle to SQL data migrations: The first is the Oracle to SQL Server Migration Assistant (SSMA). It is a fairly basic tool and if you don't have any binary objects to migrate it is ok. It allows you to create the schema and migrate the data, but it isn't the fastest tool in the world and the OLE drivers wont work with binary ...


2

You can connect to Oracle from SSIS. You have to install Oracle client on your development and also on your production environments. After doing proper tnsnames configurations you can use odbc source or ado.net source.


0

Copy step of your job will just inform operating system to start copy process and will mark this step completed and this will initiate next step "Restore Database", but meanwhile operating system is still copying your file to destination. Before restore, you must verify file existence first. Declare @file_exists int EXEC xp_fileexist 'c:\MyDatabase.bak', ...


1

Amusingly enough, you have the answer in your question, specifically, run as. RunAs and in case MS butchers links again, RunAs RunAs allows you to run a program as another user. You can't automate the entry of credentials, which is a pain and you won't be able to see your password but it does work. It also fails in situations like SSRS development when you ...


-1

You can use Configuration files in SSIS. You have to enable your package to use them and then edit the .config file to override the package connection properties with the properties (username/password/Server/etc.) you want it to use.


0

I ended up using a PowerShell step in SQL Agent to work around this: job step type "PowerShell" with a short script, which uses Invoke-Sqlcmd to call the stored procedure. Feels awkward, but it works under the alternate credentials.


1

No. SSD-BI edition is now a free download. That license allows you to develop SSIS packages that target a 2012 SQL Server Integration Services machine. That license does not grant you the right to use it for production-like usage. Furthermore, when you try to run a package from the command line, you're going to be met with an exception stating that ~ this ...


0

I remember reading that back in SQL Server 2000 DTS executable and binaries were redistributable. Which at that time you just had to have a CAL license for SQL Server. Microsoft more or less removed that clarity with regards to SSIS when it was first released. However, as noted in the link some portions of BOL note that SSIS is not redistributable like SQL ...


1

Try setting the ValidateExternalMetaData property False and then try, quite possible due to run time allocations. Also set DelayValdiations to True, wherever applicable. If it does not solve, then let me know!!


1

The problem lies in the referencing. You might have copied the package from an older one and are making the changes or you might have edited the connection managers. The connection managers are internally used using the GUID that you have mentioned. You might have changed most of the references from the UI, but still there are some objects and tasks, that ...



Top 50 recent answers are included