Search results for query: *

Hello all, my troble is probably very simple. My package contains 100 of 'Execute SQL Tasks', which are ordered in hierarchy, so between them are all kind of flows . If i try to execute whole package it can't make any update on server. But when i trying to execute task by task it works...

Thanx gradley, i need to begin this package with this message and declare this variables in the beginning of package: ................ declare @SecuritySettingsReplace bit set @SecuritySettingsReplace=0 if (@SecuritySettingsReplace=1) begin DELETE FROM SecurityAccessRights DELETE FROM...

Hi Everybody. I need to make user-friendly interface in the beginning of execution of package. It have to be something like dialog box with one switch how package should works. After click "Execute" it starts another MSG BOX like "You want to replace security tables" with only two chances "Yes"...

Dear DBomrrsm, I knew that was reason of my troubles. Thanx very much. But the error messages was absolutelly different that i was expecting.

I'm sorry, i solved my problem :0). Troble was with declaring @SQLString NVARCHAR(500)...i just increased number to 1500 and everything is ok. DECLARE @SQLString NVARCHAR(1500)....I'm not good in this, can anyone explain me why it works now? Thanx and really appreciate

Hi, this is my trouble...For me, this code is perfect, and actually it was yesterday, but now it shows me message:"the column prefix 'ID_Rank'does not match with a table name or alias name used in the query " Why? how can i solve it? CREATE PROCEDURE dbo.PersonSkillView1 as if exists (select...

Hi Everybody, i'm transfering one big SQLscript into DTS package. Here is my problem. Whem i'm puting 'Create procedure' from that script into stored procedures, it always tells me that I didn't declare values(@WorkForce INT,@Recr_ID INT)...here is code from that script: -- Create Import...

Hi Everybody, i'm transfering one big SQLscript into DTS package. Here is my problem. Whem i'm puting 'Create procedure' from that script into stored procedures, it always tells me that I didn't declare values(@WorkForce INT,@Recr_ID INT)...here is code from that script: -- Create Import...

I understand all this begining processes...my trouble is to divide, reconstruct that Update script into tasks-objects which are used by DTS. Connection is between access DB and MSSQL, i need to transfer migrating files from Access to MSSQL and run this script using DTS packaques during this...

Hi, i need to change Update script of company recruit database to any kind of DTS packague...i'm absolutely new in this area, so any possibilities and solutions are very aprecciate. Actually i need just idea how to start.. This update script contains all creates,inserts and updates of...