Viewing 15 posts - 11,821 through 11,835 (of 13,849 total)
Is the requirement exactly the same for each server?
Is the schema exactly the same for each server?
If so, you can execute the same process over and over again, against the...
October 3, 2010 at 5:08 am
OK, I've just mocked this up and it works.
First, I have two package-scoped variables:
DropTablesSQL - object
strSQL - string
Next, a script task with DropTablesSQL in ReadWrite variables:
Public...
October 2, 2010 at 1:37 pm
Going back to my suggested method, can you confirm that you had configured the variable mappings page for the FEL?
October 2, 2010 at 5:04 am
The datatype of your array variable needs to be Object.
Once it has been populated, you can feed it into a Foreach loop.
Change the enumerator to 'Foreach From Variable'. The...
October 1, 2010 at 8:31 am
What is the data type of dropTablesSQL?
Please post the error message.
October 1, 2010 at 1:27 am
I second Alvin. You're going to have to build in a lot of logic rules and what-ifs to make that work.
September 30, 2010 at 8:34 am
Not easily. Rewrite in 2005 and deploy, or upgrade server to 2008 and deploy.
September 29, 2010 at 2:54 am
Have you got an instance of SS2005 running on the machine you are deploying to?
Check for the existence of multiple dtexec.exe files on the deployment machine.
September 29, 2010 at 1:44 am
19th Century?:w00t:
Your very first post used 30-DEC-99 as an example, so it's not surprising that some confusion was caused.
September 28, 2010 at 8:55 am
You might find something interesting in this thread.
September 28, 2010 at 8:33 am
jango_41 (9/27/2010)
when a trigger is to be defined in c#, you must define something like :
[Microsoft.SqlServer.Server.SqlTrigger(Name = "UpdateAddressChangeLogADDRESS", Target = "ADDRESS", Event = "FOR UPDATE")]
I may be wrong,...
September 28, 2010 at 7:32 am
rjames-833409 (9/28/2010)
bump
Did you check out the HTTP Connection Manager and, if so, what were your findings?
September 28, 2010 at 7:28 am
Deepthy (9/28/2010)
I am new to SSIS Please bare with me.
Here is my scenario.
I have two tables TableA and referetable TableB
create table tablea ( country varchar(100),city varchar(100),clean_city varchar (100))
Create table...
September 28, 2010 at 3:47 am
Raunak Jhawar (9/24/2010)
(and admit, VB or C# is probably a lot easier than WQL :-D)
-- ...try something new everyday...;-)
One day a German beer, then a Belgian one, then Czech, ......
September 24, 2010 at 7:44 am
Raunak Jhawar (9/24/2010)
da-zero (9/24/2010)
1. Add a script task.
2. In the script, create a directoryinfo on the directory. (let's name it di)
3. Use the getfiles method:...
September 24, 2010 at 5:44 am
Viewing 15 posts - 11,821 through 11,835 (of 13,849 total)