Try this: [ORDERDATE] == "" ? DT_DATE : RIGHT([ORDERDATE],4) + "-" + SUBSTRING( ORDERDATE, 4, 2 ) + "-" + SUBSTRING( ORDERDATE,1,2)

Yes, I just missed it, you have to list columns or use * for all columns as: (select top 1 * from _TOPICS

If you want be sure that related record exists in all tables:

SELECT _TOPICS.ID, _TOPICS.TITLE, _THREAD.TITLE, _CONVERSATION.POST

FROM (select top 1 from _TOPICS where Title in (select Title from _THREAD where DOCID...

Can you try this :

SELECT _TOPICS.ID, _TOPICS.TITLE, _THREAD.TITLE, _CONVERSATION.POST

FROM (select top 1 from _TOPICS) as _TOPICS

RIGHT OUTER JOIN _THREAD

ON _TOPICS.TITLE = _THREAD.TITLE

RIGHT OUTER JOIN _CONVERSATION

ON _THREAD.DOCID =...

If you need to run only your batch file, you do not need to create SSIS package.

You can just schedule windows job to run your file D:\SSIS\launchftp.bat"

but first you...

I had this problem. I solved it with steps:

1. Run psftp.exe from command promt, it will ask you to reply "Y" and press enter (!!!)

2. Created SSIS package with...

-c indicates that SQL Server should run as a program, and not as a Windows 2000 service. Using this parameter makes SQL Server start more quickly in a command window.

-f...

your command "sqlservr.exe –c –m" also should work, I think you have more than one SQL Server instance. In the command window you must switch to the directory where SQL...

sorry, 'Andar' is my SQL Server instance name, if you have default instance then just run Sqlservr.exe –c –f –m –s

I have done that before :

Stop SQL Server, open command line and start SQL Server in Single user mode.

Change directory to the folder where “sqlservr.exe” file is...

I use:

----------------------------------

execute master.dbo.xp_cmdshell 'dtsrun /SserverName /UloginName /Ppassword /NDTSpackageName /M'

-----------------------------------

replace: serverName = your SQL server,

loginName = your login,

...