Viewing 15 posts - 9,076 through 9,090 (of 13,876 total)
Have you considered setting the security on SQL Server so that these devs do not have the rights to deploy to your selected server(s)?
Sounds much easier (and more achievable) than...
September 20, 2014 at 2:40 am
Welsh Corgi (9/15/2014)
So I would need to have a Stored Procedure...
September 15, 2014 at 6:45 am
Please do not cross-post in future, it wastes people's time and fragments responses.
Responses here please.
September 14, 2014 at 4:24 am
I haven't tried this, so I'm not sure, but:
Click on the ExecutePackage task and look at its properties.
In particular, look at ForcedExecutionValue and ForceExecutionValue.
If you set ForceExecutionValue to true, the...
September 14, 2014 at 4:17 am
What are the datatypes of the source and target columns (in the physical tables)?
September 11, 2014 at 12:43 am
miskeens (9/10/2014)
I have 3 different databases on same sql server which contains many tables.
Database A - Consists of 25 tables.
Database B...
September 11, 2014 at 12:42 am
dwilliscp (9/10/2014)
SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider...
September 11, 2014 at 12:39 am
mandavli (9/10/2014)
SSIS packages run at night and getting email is not a good option. is there a way i can set up ssis to make phone call if package fails?
Nothing...
September 10, 2014 at 6:43 am
rena24 (9/10/2014)
Hello everyone and thank you for the Answers!Phil your solution is great!!! Thats exacrly what I need! Quick and clear!
Thank you very very much!
🙂 Thanks for posting back with...
September 10, 2014 at 6:16 am
Have you tried looking at the 'All Executions' report for the package?
More info here.
September 10, 2014 at 2:12 am
DataEnthusiast (9/9/2014)
Problem Statement:
The flat file souce should pick the file with keywords matching...
September 10, 2014 at 1:33 am
rena24 (9/9/2014)
I want to ensure something. I must insert some files in my SQL Server Database. I use the traditional way. Oledb connection to SQL Server and fast load....
September 10, 2014 at 1:29 am
Welsh Corgi (9/9/2014)
Welsh Corgi (9/9/2014)
I need a Script to change SQL Server and SQL Server Service Logins.Does any one have a script to do this?
Hi.
Why did you remove your post?
Talking...
September 10, 2014 at 1:25 am
pgmoschetti (9/9/2014)
- it's a SCADA software (Citect SCADA)
- the SQLExec is using ADO.NET behind the scene
- the four SQLExec...
September 9, 2014 at 7:16 am
This depends on how 'SQLExec' is implemented. More details needed about that before we can answer.
September 9, 2014 at 3:38 am
Viewing 15 posts - 9,076 through 9,090 (of 13,876 total)