ya true BCP we can use it, but again there is one problem using BCP, In my table there is one column as varchar and in that column values as...

Here I have question, I am using SQL server as remotely, and I am trying to create Excel file using SSIS, so on local machine its works fine, but when...

Because as per my knowledge VARCHAR(max) stored that much space that is available for each row, if one row have 15 character then it is stored only 2 bytes,...

ya that is right but i have two syntax for Re-build the index

1) Re-building the index using Alter Index command

or

2) Drop the index and Create Index again

which one is...

Jack

The location of that file and folder is not on server side but its on common Network share drive and for the server rights we have only one user to...

SSIS Package executing by one of SQL Job everyday when i put that package on server and test it gives an error as Command line parameter are Invalid, step failed....

Thank you all, it helps lot

ya that is right if we can put Text format, that is possible but if suppose every time i want to see New Excel file then how can i change...

If suppose I want to see every time new excel sheet then how can we change the Text format in Excel sheet, because everyday its looking new file from SQL...

Its not working, here i will show you an example

create table file1(Loan_Number varchar(10))

insert into file1 values('0000012345')

insert into file1 values('0000045678')

insert into file1 values('0000009876')

Now here is the query

Exec Master..xp_cmdshell 'bcp "SELECT loan_number...