Viewing 15 posts - 976 through 990 (of 1,118 total)
BryanCompton (1/11/2009)
January 12, 2009 at 10:25 am
bharatmadhira (1/8/2009)
how do u describe about a job sehduling in SSIS
You can use SQL Job Agent API. Check this script for ideas.
January 9, 2009 at 1:12 pm
ns.sharath (1/9/2009)
Is there any way to count blank values in column of Excel ?
Did you try:
select count(*) from sheet1$ where column1 is null;
January 9, 2009 at 1:10 pm
jonathan_harley (1/9/2009)
I have already explored different potential, non-bcp formatted options. We cannot force our client to switch their interface, we need a bcp compatible...
January 9, 2009 at 11:41 am
malcolmwatt (1/8/2009)
(1) I'd like to execute an SSIS package against a file in an FTP folder on Windows Server 2003.
(2) I'd like to do it . . . whenever there's...
January 8, 2009 at 10:52 pm
jonathan_harley (1/8/2009)
The reason being that we export volumes of data...
January 8, 2009 at 10:42 pm
leighton_d (1/8/2009)
Ah! Makes sense. Might you have a connection string example that would speed me on my way?Thanks again...
Try setting each and every property like this:
ServerName=server name;ServerUserName=user name;ServerPassword=password;
January 8, 2009 at 9:28 am
leighton_d (1/8/2009)
I found the "Expressions" in the connection manager, but there is not an expression for "ServerPassword".?
Most probably this is made on purpose for security reasons. You have to setup...
January 8, 2009 at 9:18 am
leighton_d (1/8/2009)
January 8, 2009 at 8:32 am
ckmoied (1/8/2009)
ok just a clue, I have installed sql2005 express. I think ssis is not the part of it. If not, then how can I add ssis.
You have to have...
January 8, 2009 at 7:09 am
dyana (1/8/2009)
i created a proxi account and now it is working.. thousands of thanks for all of you people..
but script is throwing pop up's some times like want to...
January 8, 2009 at 6:57 am
dyana (1/7/2009)
i did not try for proxy account.. actually if i disable the script task, then im able to schedule the package. it is running smoothly. but the problem occurs...
January 7, 2009 at 10:48 pm
dyana (1/7/2009)
you are absolutely correct... i'm trying for excel automation only.. how can i check that i have enough permissions or not.. wat i have to do.. now im working...
January 7, 2009 at 10:29 pm
binford79 (1/7/2009)
WOW what a shame on SQL 64bit! then back to 32bit....If you get an Resolution from MS, you are wolcome to inform us !!
thx.
Do not expect resolution based on...
January 7, 2009 at 8:06 pm
dyana (1/7/2009)
im having a script task which opens an excel file and extract some data into database. when i run this package it run successfully. but when i schedule this...
January 7, 2009 at 7:21 am
Viewing 15 posts - 976 through 990 (of 1,118 total)