Good Question. I got it wrong. I did not see that the sp started with sp_.

In my company we follow the standard of not using sp as starting letter for...

I have had the same issue before with indexed views and I could not never get it working. Looks like this is the limitatiion of indexed views (cannot use derived...

How are you testing the output in SSIS?

For starters Select top 1 (any 1 column) record instead and save it in a variable and see if the variable displays the...

Use Expression and Constraint Option. This may help.

Hi,

Hope this helps you.

DECLARE @Temp Table

(

FirstName VARCHAR(100)

)

INSERT INTO @Temp

SELECT '-Charlie'

UNION ALL

SELECT '*Charlie'

UNION ALL

SELECT '<Charlie'

UNION ALL

SELECT '<<Charlie'

UNION ALL

SELECT '<<<Charlie'

UNION ALL

SELECT '$Charlie'

UNION ALL

SELECT 'Charlie'

SELECT SUBSTRING(FirstName, PATINDEX('%[A-Z ,a-z]%' , FirstName), LEN(FirstName)) AS FirstName

FROM

@Temp

yes I process the files and move it to an archive directory once I get the files in my working directory and process them.

The problem was with i should be...

It might be possible that the file download on your source directory is not complete and at the same instance you are trying to move the file. 2 Processes are...

Thanks for the reply. I could not interprete the code very well.

All I am looking for is a .NEt code that would be something similar to

FOR EACH subfolder...

Hi,

I could not find a solution to define at the sp level but I have found a way to make it more generic

using database_default

So if there are collation issues because...

I have figured that this is an issue only when we query from management studio.

It is not an issue when querying using the xquery for a table having an xml...

I have figured that this is an issue only when we query from management studio.

It is not an issue when querying using the xquery for a table having an...

As this is my first experience with XML I am finding it difficult and seeking the advice of the SQL & XML gurus. Can you please point me in the...

You have been very helpful all through my issues with parsing XML. But I have run into a problem that I have posted in the TSQL forum as well but...

Thanks lutz,

You have been very helpful all through my issues with parsing XML. But I have run into a problem that I have posted in the TSQL forum as well...

Thank You all, we figured out that it is not an issue with SSIS or the parameter but rather .NET and AXIS incompatability. Because even the code developed in .NET...