Viewing 15 posts - 16 through 30 (of 88 total)
I removed the order by within the over clause and it worked. Thank you.very much. You are a champion.
August 28, 2018 at 10:11 am
Hi femi,
See the error below and I bold it .Thanks.
Msg 102, Level 15, State 1, Line...
August 27, 2018 at 6:13 pm
Hi femi,
Thanks for your help. I ran your query but ran into error on the select statement query below on the order by after the CTE. Any ideas?
August 27, 2018 at 2:43 pm
Hi Phil,
I changed the format in aligned to the header with spaces and between fields. For somehow, SQLsevercentral trimmed the leading space on each row values.
August 24, 2018 at 11:51 am
Hi SSC Guru,
Is this good enough? Thanks.
FID AccountNum Spike_Reading_Day SpikeVal Flag
34166 TT0034166 2018-08-17 150 P
34166 TT0034166 ...
August 24, 2018 at 11:47 am
I know this post has been a while. I am in the same situation trying to use SSRS invoke Excel printing format with landscape, tabloid, 17 X 11 and fit...
December 4, 2017 at 9:36 am
PhyData,
Do you have an example how to call the web services and pass the complex type in XML on the SSIS script component with VB? Please advise.
Thanks,
July 8, 2014 at 7:38 am
That is correct. However my method is an XML complex types. Will the delimited works without the xml tags? I have tried inserted xml string into the variable but got...
June 30, 2014 at 8:18 pm
Alan,
I am having the same problem. Have you figure out how to input multiple complex value types?
Thanks,
May 20, 2014 at 1:52 pm
make sure you have added the COM objects to the SSIS from your .NET framework library. It should be on the SSIS Design tools somewhere.
Thanks.
September 29, 2010 at 8:47 am
Hi Jack,
Thanks for your help. I am still learing the C# language. On the deflaut script task in C# where does code fit into below. The code in red is...
January 22, 2010 at 8:41 am
Hi,
Do you have examples in C# to call a store procedure in a script task?
Thanks
January 21, 2010 at 12:38 pm
Hi Sabya,
I am on SSIS 2008 and here is what I did on the Execute SQL task
ConnectionType = OLEDB
Connection - 1) I clicked New connection
...
December 30, 2009 at 8:03 am
I have a sQL statement that called the constant path value that resides on a table that I am trying to input to my variable. However, the constant path value...
December 30, 2009 at 7:15 am
Hi Sabya,
I have already configured the configuration file now how can I get the
"Execute SQL Task" point to this C:\PackageConfigurations\Environment.dtsConfig file. Please advise. Thanks.
December 30, 2009 at 12:05 am
Viewing 15 posts - 16 through 30 (of 88 total)