how to loop through my workflow by looking at the file system?

Hi, not sure my subject title makes it clear what I want but here it is.

I have a workflow which basically looks at an excel file in a folder on the local drive and then does loads of stuff to it. Everytime I want to process a different excel file that is in the same location al I have to do is change the value of a single local variable, which is just the name of the excel file.

Is there a way to make this automatic? For exmaple....could I somehow put my whole workflow inside a loop that looks inside that local folder and one by one, get the name of the file, assigns the name to that global variable, and then runs the flow...and continues to do that until it gets to the end?

any help would be greatly appreciated...thanks!!!!

andy

Have you look at the ForEachLoop container in the control flow? you can use it to loop through each excel file in a specific folder.

|||awesome, thanks!

how to login in sql server with certification login

hi all,

i have created a login account using certificate.

--CREATE A CERTIFICATE--

CREATECERTIFICATE TEST_CERTIFICATE123

WITH SUBJECT ='CERTIFICATE IN TEST DATABASE',

START_DATE='06/04/2007',

EXPIRY_DATE ='02/02/2009';

GO

--CREATE LOGIN FRON THE CERTIFICATE

CREATELOGIN LALIT12301 FROMCERTIFICATE TEST_CERTIFICATE123;

GO

How can i use this login credential to login to microsoft sql server management studio.It is askin only for sql/windows authentication.There is no option for the certificate based login.

if i m passing this login id as sql server authentication then i m getting following error.

Login failed for user 'LALIT123'. (Microsoft SQL Server, Error: 18456)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

please do help me.....

It is not currently possible to login to SQL Server as a certificate Login.

These kinds of logins are used for signed modules and allow some finer grained access control to pieces of code because you can grant permissions to the certificate login, sign a procedure with the certificate and anyone who has execute permission on the procedure will have the additional permissions granted to the certificate login WHILE the procedure is executing.

HTH,

-Steven Gott

SDE/T

SQL Server

|||

Hi Steven

Thanks a lot..............