good editor tools for script file

Hi, can anyone suggest a good and free editor tools for script file? so it
would be eaiser to tell the begin... end...I don't use any specialized editor. I use Query Analyzer or Textpad, and I
find them more than adequate.
Linchi
"tulip" wrote:
> Hi, can anyone suggest a good and free editor tools for script file? so it
> would be eaiser to tell the begin... end...|||I HIGHLY recommend ApexSQL Edit, although it isn't free. Blocking out
BEGIN/END pairs is just one of hundreds of nifty features.
--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"tulip" <tulip@.discussions.microsoft.com> wrote in message
news:B42DFFB2-4CA9-4026-B7A5-DAC37E1391AF@.microsoft.com...
> Hi, can anyone suggest a good and free editor tools for script file? so it
> would be eaiser to tell the begin... end...

good editor tools for script file

Hi, can anyone suggest a good and free editor tools for script file? so it
would be eaiser to tell the begin... end...
I don't use any specialized editor. I use Query Analyzer or Textpad, and I
find them more than adequate.
Linchi
"tulip" wrote:

> Hi, can anyone suggest a good and free editor tools for script file? so it
> would be eaiser to tell the begin... end...
|||I HIGHLY recommend ApexSQL Edit, although it isn't free. Blocking out
BEGIN/END pairs is just one of hundreds of nifty features.
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"tulip" <tulip@.discussions.microsoft.com> wrote in message
news:B42DFFB2-4CA9-4026-B7A5-DAC37E1391AF@.microsoft.com...
> Hi, can anyone suggest a good and free editor tools for script file? so it
> would be eaiser to tell the begin... end...

Going from byte() to File Open of Download

Hello, I'm having users upload documents to my db and storing them as an Image datatype, I can do that without an issue. I'm also able to find that record and return it as a byte(). Now, what's the best practice/scheme to return it to the browser, even FF, and have it prompt the user with the Open or Download thing Dialogue we all know and love.

Thanks in advance.

bump|||

Hi,

When you get the file from database, you can send it to the browser using HttpResponse.WriteFile method.

Here is a link for more information about this method.

http://msdn2.microsoft.com/en-us/library/dyfzssz9.aspx

HTH. If this does not answer you question, please feel free to mark it as Not Answered and post your reply. Thanks!

GoDaddy SQL Web Admin -- Importing CSV file

Okay -- Frustrated... any guideance appreciated.
Our website is currently using an MS-ACCESS file for it's back end
database. Hosted on GoDaddy. Due to performance issues, we are
switching over to GoDaddy's MS-SQL Server. Our only management tool is
the SQL WEB ADMIN.
The only way we can see to import data into a table is through
importing a csv. THIS IS FINE!
We went to access, and exported the tables, using a comma delimited,
text identiffier of quotes, and imported it into sql through the SQL
WEB ADMIN.
EXCEPT -- all the text fields physically kept the quotes.
A field that previously contained: Hello kitty, how are you
Now contains "Hello kitty, how are you"
We have several long descriptions and text fields that contain commas
and semi-colons so we definately need a text identifier. So how do we
export the file from access and successfully import it into our godaddy
hosted SQL server using ms SQL WEB ADMIN?
Any help, guidance, comments would be greatly appreciated.
Don O
Palm Springs, CA
president@.palmspringsbears.org
You can use DTS package to migrate data from MS ACCESS to direct SQL Server
without exporting to csv.
-MB
"BigDesert" <doldenburg@.bigdesert.net> wrote in message
news:1167600961.063396.234590@.n51g2000cwc.googlegr oups.com...
> Okay -- Frustrated... any guideance appreciated.
> Our website is currently using an MS-ACCESS file for it's back end
> database. Hosted on GoDaddy. Due to performance issues, we are
> switching over to GoDaddy's MS-SQL Server. Our only management tool is
> the SQL WEB ADMIN.
> The only way we can see to import data into a table is through
> importing a csv. THIS IS FINE!
> We went to access, and exported the tables, using a comma delimited,
> text identiffier of quotes, and imported it into sql through the SQL
> WEB ADMIN.
> EXCEPT -- all the text fields physically kept the quotes.
> A field that previously contained: Hello kitty, how are you
> Now contains "Hello kitty, how are you"
> We have several long descriptions and text fields that contain commas
> and semi-colons so we definately need a text identifier. So how do we
> export the file from access and successfully import it into our godaddy
> hosted SQL server using ms SQL WEB ADMIN?
> Any help, guidance, comments would be greatly appreciated.
> Don O
> Palm Springs, CA
> president@.palmspringsbears.org
>
|||I don't use sql web admin so can't really help much there.
However, if you have access to a sql client tool like Query Analyzer, you
can read data from Access (via opendatasource or openrowset) and insert it
directly into sqlserver table.
e.g.
INSERT into SqlTable
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="x:\godaddy\myAccess.mdb";User
ID=Admin;Password=;')...myAccessTable
INSERT into SqlTable
SELECT *
FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',
x:\godaddy\myAccess.xls.mdb';'admin';'', myAccessTable) as x
-oj
"BigDesert" <doldenburg@.bigdesert.net> wrote in message
news:1167600961.063396.234590@.n51g2000cwc.googlegr oups.com...
> Okay -- Frustrated... any guideance appreciated.
> Our website is currently using an MS-ACCESS file for it's back end
> database. Hosted on GoDaddy. Due to performance issues, we are
> switching over to GoDaddy's MS-SQL Server. Our only management tool is
> the SQL WEB ADMIN.
> The only way we can see to import data into a table is through
> importing a csv. THIS IS FINE!
> We went to access, and exported the tables, using a comma delimited,
> text identiffier of quotes, and imported it into sql through the SQL
> WEB ADMIN.
> EXCEPT -- all the text fields physically kept the quotes.
> A field that previously contained: Hello kitty, how are you
> Now contains "Hello kitty, how are you"
> We have several long descriptions and text fields that contain commas
> and semi-colons so we definately need a text identifier. So how do we
> export the file from access and successfully import it into our godaddy
> hosted SQL server using ms SQL WEB ADMIN?
> Any help, guidance, comments would be greatly appreciated.
> Don O
> Palm Springs, CA
> president@.palmspringsbears.org
>
|||Don O,
I just got off the phone with GoDaddy. They are telling me that what you are trying to do won't work on their servers~ I am trying to do the same thing.
Have you gotten yours to work yet?
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com
|||Frankly, I'm not surprised. What you folks want to do amounts to sitting
at the keyboard of their server and having at it...
Regards,
Hank Arnold
Angie D wrote:
> Don O,
> I just got off the phone with GoDaddy. They are telling me that what you are trying to do won't work on their servers~ I am trying to do the same thing.
> Have you gotten yours to work yet?
>
> EggHeadCafe.com - .NET Developer Portal of Choice
> http://www.eggheadcafe.com

Globals!FileName.Value?

Does anyone know if there is a Global that stores the file name? I am
looking to put something in the footer that lists the path and filename
of the report.
=Globals!ReportFolder + Globals!ReportName
Doesn't seem to work...any suggestions'
thnx
-benScratch that...it works ;-)
sullins602 wrote:
> Does anyone know if there is a Global that stores the file name? I am
> looking to put something in the footer that lists the path and filename
> of the report.
> =Globals!ReportFolder + Globals!ReportName
> Doesn't seem to work...any suggestions'
> thnx
> -ben

Global variable scope - across package

Hi,

I have a Main.dtsx file which is having executing some 10 .dtsx packages. Can I declare a variable in Main.dtsx and use it in all the other packages which it is executing?

Note: I am using Yukon April CTP

Thanks
HariniYes you can. This post explains how: http://blogs.conchango.com/jamiethomson/archive/2005/09/01/2096.aspx

-Jamie|||Thanks. This is what exactly I want.

Giving understandable name to excel file when exporting with RS

Hello every body,

I'm trying to export excel file on with reporting services. My file has about 50 sheets and reporting services gives them the default name "feuille1, feuille2, feuille3, feuille4 etc....). I would like to give a valid and understandable name to that sheets. In fact i would like to give the name of each page to my sheet. The name of the page was specified in the report query.

Could someone help me please...

Thanx

I do not think that is configurable but you can try asking that question on the SQL Server Reporting services forum: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1

Even though it might not be the most fun task, you could always manually rename those sheets to have more meaningful names atfer you exported the report.

Good luck!
Othmane