Viewing 15 posts - 11,491 through 11,505 (of 13,857 total)
You haven't really answered the question - please look at it again. There is an article here which may give you some useful information about query analysis.
March 20, 2011 at 12:36 pm
Or you could execute the SQL Agent job from a batch file instead - something like:
osql -E -Q "msdb.dbo.sp_start_job N'MyJob'"
March 18, 2011 at 8:49 am
It seems that Powershell can do it too. See here.
March 18, 2011 at 8:29 am
I suggest that you start editing your query manually & testing the results in Management Studio. Query builders can get you only so far.
March 18, 2011 at 6:30 am
Yes, SSIS still uses this archaic form of not equals
Not that archaic ... so does C#.NET 🙂
March 17, 2011 at 6:37 am
OK, simpler version:
public void Main()
{
...
March 17, 2011 at 2:31 am
If possible, I would approach this slightly differently.
1) Set up your trigger to write data to a 'pending' table every time there is an update.
2) Create an SSIS task to...
March 16, 2011 at 10:49 am
Not quite.
You know that for some c.chg_ref_num, the filtering works as expected and for others it does not.
The suggestion is to find one that works and one that does not...
March 16, 2011 at 9:27 am
Please do this, as suggested already by Ninja's_RGR'us:
What I mean is find a row that is not correctly filtered. Get the input param from that row and run the function...
March 16, 2011 at 9:11 am
SUPER SQL STAR (3/16/2011)
for my project purpose
That's it? You expect others to take the time to craft a technical response to a question when you are not even prepared...
March 16, 2011 at 7:47 am
Perhaps you would be courteous enough to answer Lynn's question?
March 16, 2011 at 7:33 am
Jeff
FINDSTRING is a built-in SSIS function, see here.
March 16, 2011 at 6:17 am
Description
D-1,D2
D-2,D-U,T1
U-5,T2,K-5,T3
NULL
Is that real sample data? Or have you tidied it up to remove trailing commas, perhaps?
If it is real, you are going to get errors with your derived columns in...
March 16, 2011 at 6:14 am
KrishnaChaitanya (3/16/2011)
I have created a package which loops through a folder containing Excel inputs and loads in to the SQL server database. I have deployed the package in SQL server...
March 16, 2011 at 5:34 am
Viewing 15 posts - 11,491 through 11,505 (of 13,857 total)